All,
In my excel challenge, I have a report that produces multiple pivot tables. However, because of a reorg, I need to produce multiple versions of the same report for each new division.
These pivot tables have Column Headings like "Word, Excel, PowerPoint, Acess, OneNote, Bob"
But not all divisions will have all of the columns every week. For example, the Chandoo Division may have items under Word, Excel, PowerPoint and Access, but nothing under OneNote and Bob one week. The next week, the Chandoo Division will have something in all of the columns. But I need to show all of the columns in the pivot table, making sure that columns without data have zeros.
Is there a way I can designate a permanent range for the pivot table headers?
I plan on using the excellent Advanced Filter tutorial from about a year ago, to split the data into multiple files (Thanks Chandoo!).
In my excel challenge, I have a report that produces multiple pivot tables. However, because of a reorg, I need to produce multiple versions of the same report for each new division.
These pivot tables have Column Headings like "Word, Excel, PowerPoint, Acess, OneNote, Bob"
But not all divisions will have all of the columns every week. For example, the Chandoo Division may have items under Word, Excel, PowerPoint and Access, but nothing under OneNote and Bob one week. The next week, the Chandoo Division will have something in all of the columns. But I need to show all of the columns in the pivot table, making sure that columns without data have zeros.
Is there a way I can designate a permanent range for the pivot table headers?
I plan on using the excellent Advanced Filter tutorial from about a year ago, to split the data into multiple files (Thanks Chandoo!).