Replies

Correction to my last post, CPU goes to 100% but then drops as soon as I go over to the server and move the mouse.

System Idle Process is always at the top under CPU. Could it be my screen saver? The server will slow down, I’ll go to take a look at performance monitor and I’ll see that the CPU has been at 0 but it drops as soon as I move the mouse (which made the screen saver stop). What is System Idle Process? Thanks for the help.

Thanks John. I tried your method and it worked as well. I guess I didn’t have the grand total as part of the highlighted area. Thanks again for all the help.

Servando,
I got your formula to work! Thank you all very much for your help. This has been a good learning experience.

Wassim,

I tried to get your formula to work but I’m doing something wrong. Could you look at the attachment and let me know? Thanks.

JohnBF,
I was able to do what you had in your attachment except when I collapse and try to sort at the subtotal level, I get this message, “This removes the subtotals and sorts again. If you want to sort the subtotaled groups, choose the cancel button; then collapse the outline and try again.” I did this and continue to get the same message. Haven’t been able to get it to sort.
Thanks.

I don’t understand the formula in column B. I’m not too knowledgable on this stuff. Column E is my column with the totals for each year and then the grand total. I’d like to put the formula in column F. How would this work? Thanks.

I didn’t create this spreadsheet. It was just given to me and they definitely want to see each year and the totals, then sort by the totals. Just like my first post. Any ideas?

Thanks, it’s working now. Those links helped. Now I just want to know how to record the sound so that the CD doesn’t have to be in the CD ROM. I want to burn a copy of the presentation and have the music file as part of it. How is this done? Thanks.

You’re right. Some of the codes start with a V so this won’t work. I think I’ll just have to fix this one by hand. Thanks.

Thank you very much! Worked perfectly.

Thank you very much! The macro worked perfectly.