Recent content by susejdrol

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