pivot table based on 4 others (in seperate workbooks)?

N

neowok

basically I have aspreadsheet for each week with people and hours in
them, and in each weekly spreadsheet i have a pivot table which adds up
and summarises the hours for the people for that week.

What I need to do is get a pivottable which adds together those 4 pivot
tables to give me the same summary, but for all 4 weeks together.

I dont seem to be able to make a pivot table based on 4 pivot tables in
other workbooks, so can anyone suggest the way to solve this?

thanks
 
C

CyberTaz

Hello-

You are right. PivotTables are based on a single range of data.

What you need to do is create a worksheeet that summarizes the data from the
other 4 and base a new PivotTable on it.

BTW- You might also want to take a look at the Data>Consolidate features for
similar/related purposes.

HTH |:>)
 
Top