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