Hello everyone, I'm new to this site and would like some help. I have 3 questions.

1. I have a pivot table where I would like to format the Total rows. Shade them as grey, and Bold the field.

Is there a macro or Visual Basic code that can do that automatically ?

2. In the same pivot table, I have calculation that references to the Grand Total line. But every month based on my data source, the grand total will "shift", 1 month it can be on row 27, the next month it can be on row 45. Every month I have to manually change my formula to refer to the Grand total line. What's the best way to fix this?

3. I use to have a macro that would open up other excel files, copy the information, and paste it in the original file. But now since some of the files no longer have data in them, it would crash. How can I write a code to open up the file, determine if it has data, if it does, copy it's contents, and go to the next file without crashing?

Thanks!