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
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