How to use mutiple spreadsheets in a pivot table?
I am trying to use multiple spreadsheets to create a pivot table in order to
analyse corporate profitablility. I am relatively new to pivot tables and can
find little help in this area.
I have a spreadsheet with a number of tabs, with a reconciliation page that
currently uses arrays and lookup to access the data from a couple of the
other tabs. I think a pivot table would work better. any ideas?
Thanks,
-Ian
|