Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot table retrieving data from several worksheets
Hi guys,
I have data for several countries in one workbook. Every country has its own worksheet, and every worksheet has exactly the same structure. I've prepared an additionnal "summary" worksheet, but I would need to retrieve 3 different sort of data (quantity by task, amounts by task, person ID No executing the task). The summary would be (ideally) organized in the following matrix: in lines we have countries, in columns we have the days (F. ex. 01/Dec/04 - 31/Dec/04). For the time being, I created 3 different "summary" matrices, but I'm asking myself if pivot tables would not be a better solution. However, I've never done pivot tables from multiple worksheets. Is it possible? Thanks for your help! Wishing you a great end of the year, Gizmo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get pivot table data columns instead of rows | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Data Table - does it work with DDE links and Stock Tickers? | Excel Worksheet Functions | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
copy pivot table to multiple worksheets | Excel Worksheet Functions |