View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AndyL82 AndyL82 is offline
external usenet poster
 
Posts: 3
Default Multiple PivotTables on one spreadsheet

Hi, I'd like to create a spreadsheet that includes data about a product -
name, dimensions, how much was sold over the last few weeks etc. - extracted
from multiple spreadsheets. Is it possible to use multiple PivotTables to
show this data on one spreadsheet, but only one 'page field' with which to
select the article name? I don't want the sales data and dimensions data in
one PivotTable as this would make it too big... but I also don't want to have
to change the page fields of separate PivotTables.
Thanks for your help.

--
Andreas L.