| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table for Consolidated Reporting
Hi...
We are maintaining a Report for individual users with details of work done by them during the day. The Report contains details such as: 1) Date 2) Name 3) Client 4) Version of Work Done Now, we need an automated Consolidated Sheet with Sum of versions done for each Client by each Person on a specific Date. I tried using the Pivot Table... I am not well versed with Pivot Tables. Can we make a Pivot Table by selection the specific ranges from multiple (individual) Sheets so that we can get this data... Please help me with this. Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate a pivot table that has consolidated multiple worksheets | Excel Discussion (Misc queries) | |||
| Combining worksheets/tables into one consolidated table (or pivot | Excel Discussion (Misc queries) | |||
| reporting with pivot table? | Excel Worksheet Functions | |||
| Consolidated Pivot table | Excel Discussion (Misc queries) | |||
| Reporting results of pivot table | Excel Worksheet Functions | |||
Threaded Mode
