I'm using Excel 2003. My spreadsheet has 9 Department tabs, each with 10
Funding Source Categories columns and 20 Expense Category rows. Not all the
Departments use all of the Funding Sources or Expense Categories. I have a
Master Pivot table based on all Departments combined: Departments are pages,
Categories are columns, Expense Categories are rows, and data is sum of $. I
want to pull the Expense data from the pivot table within each Department,
based on the Categories actually used by that department, and I want to use
the same formula for each Department's layout (for consistency). I have
copied the master pivot table to each of the department tabs & am showing
that particular department, but since not all pages of the pivot table
generate all the rows or columns, I'm stuck. Any and all assistance would be
greatly appreciated - Thanks!!!