Crazy Dazz
New Member
- Joined
- Dec 11, 2017
- Messages
- 5
This is one of those ageless problems that I assume somebody must have been able to solve, but Google fails me.
We pull data from a Master Query using Pivot Tables.
Its an excellent tool in that users can not only view the standard reports but make their own.
The problem is that the column headers are dates that change between campaigns.
Of course then the Pivot Tables delete the existing columns and ignore the new ones.
I can manipulate the column names before it gets to the pivot table, but the problem remains.
(One option for existing pivots would be to use non-dynamic headings, then use a macro to rename the columns. But that would create problems for any new tables, and has the potential to screw things up.)
We pull data from a Master Query using Pivot Tables.
Its an excellent tool in that users can not only view the standard reports but make their own.
The problem is that the column headers are dates that change between campaigns.
Of course then the Pivot Tables delete the existing columns and ignore the new ones.
I can manipulate the column names before it gets to the pivot table, but the problem remains.
(One option for existing pivots would be to use non-dynamic headings, then use a macro to rename the columns. But that would create problems for any new tables, and has the potential to screw things up.)
