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


--
neowok
------------------------------------------------------------------------
neowok's Profile: http://www.excelforum.com/member.php...fo&userid=5940
View this thread: http://www.excelforum.com/showthread...hreadid=466288

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 DataConsolidate features for
similar/related purposes.

HTH |:)
"neowok" wrote:


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


--
neowok
------------------------------------------------------------------------
neowok's Profile: http://www.excelforum.com/member.php...fo&userid=5940
View this thread: http://www.excelforum.com/showthread...hreadid=466288