I have a pivot table that I want to change based on a cell reference. For example, my pivot table gets external data based on a Project # that is in cell C5 (selected from a drop down).
I need the Pivot Table to change automatically to the project number that is entered in B2 on the 'Title' sheet. It tells me that you can not put formulas in a Pivot Table.
Bookmarks