I am currently working on code that will take a single pivot table, copy it and paste with different information. The problem i've run into is one pivot table needs to report totals in whole numbers and the copy needs to report totals in decimals (0.00). Since the macro will be used over many project budgets, cell reference would be irrelevant and would somehow need to change the number format using the pivot table itself. I have been experimenting with various commands and have had no luck so far. Open to any suggestions at this point.