Search results for query: *

I am shooting from the hip here, but perhaps IE is not set up as his default program for web pages. Maybe he installed some other piece of software that overroad the setup in windows.

Team, I was wondering if anyone know how to insert a song into a powerpoint presentation so that it will loop throughout the presentation rather than being linked to one slide. The goal is to link music into the presentation so that it will play while the presenter is talking and not be...

That looks like it will work. Thanks for the help CP

Team, Is there any way to eliminate leading and trailing white space in all of the cells on a worksheet? Of course, I don't want to get rid of spaces that are insid the text, just the leading and trailing space that came over when I did some copying and pasting. Thanks for any ideas you may...

The macro literally just does a find and replace. After I do a paste special so that there are no fomulas in a call, it goes in and replaces every instance of "5AM to 9AM" with 1, every instance of "5AM to 2PM" with 2, etc. up though 11 differant schedules. Then it coverts...

Team, I have an Excel workbook that is used to generate a seating chart that displays relevant data by code. Currently, the way that it works is that I copy and paste the data from another workbook, then I do a past special with values to eleimate formulas, and then run a coversion macro that...

I think this is the same basic question that has been coming up on the forum for a while. I think I may have been the first to ask it in the recent past. Anyhow, the solution that we came to was: =sumproduct((Wk52!$A:$A="John")*(Wk52!$B:$B="Sale")) if you are trying to...

Team, Thank you very much for the assistance. I went ahead and used the second option just in case, and it worked perfect. Thanks again. CP

Team, I have a worksheet full of formulas that reference other sheets in the workbook, and I was going to have to delete and recreate some of other worksheets. So, I did a find and replace all to replace = with '= which made ever formula into a string. After fixing the other worksheets I went...

When you create a new macro, there is a drop down box that asks you where you want to save it. One of the options there is your personal macro workbook which is the personal.xls file they are refering to. Hope that helps. CP

You know. It never even occured to me to try that. Thanks a lot guys. CP

Team, Is there a way to add an UNLESS or AND clause to a countif. For example: Let's say you have two columns, one has group assignment and the other has a break time. I want to either count everyone whose break time is "X" and is a member of group "A", or everyone whose...

I did something very similar the other week. The solution that I came up with (with some help from several kind tipsters at Tek-Tips) was to go to the worksheet and place the person name in a cellas you have in your second example. Then do the following. A 1 Name1 2...

I just wanted to add a little point to the this that I discovered after using that tip. It worked perfectly from a visual standpoint (i.e. 8:17 became 8:15 just as expected). However, when you do a comparision (i.e. if(A1=A2, ...)) it fails because it loses some decimal places in rounding...

That worked perfect. THanks for the help. CP

Team, Does anyone know of a way to round off time. In other words, 8:20 would round down to 8:15, 8:25 would round up to 8:30, etc. I know that you can use the round function to round numbers to whatever number of places you care to go, but I cannot get it to work with time. Any ideas...

The only work around that I can think of is to use a second worksheet and keep goign where you left off. Excel will let you use data across worksheets just as if they were on the same one. If you are having to import data, you can select what data gets improted to what sheet. Other than...

That worked perfectly. Thanks a million. CP

Team, Is there a way to use the countif function and refence another cell. In other words, to ask EXCEL to count all of the cells in a range whose value is less than or equal to the number in cell B4. For some reason, I can only get it countif to work if I specify the value in the condition...

My understanding is that you are generally limited more from a hardware side than a software side. If you are going to load the presentation into memory and have it run anywhere near as smoothly as you's like, you are goign to have to limit animations somewhat. I am guessing that I have used...