excel_training_wheels
Board Regular
- Joined
- Aug 25, 2005
- Messages
- 193
Hi--
I have a workbook with 5 worksheets. Each worksheet has 20,000 product IDs and an index value.
Each one of the sheets is not unique, that is, the same product ID can exist on multiple sheets.
I am trying to build a pivot table using the product IDs from all five sheets, and have it give me a sum of the index values. Its a basic pivot, but I am running into issues trying to select the data from all of the sheets. What do I type in the range box?
Thanks for your help.
I have a workbook with 5 worksheets. Each worksheet has 20,000 product IDs and an index value.
Each one of the sheets is not unique, that is, the same product ID can exist on multiple sheets.
I am trying to build a pivot table using the product IDs from all five sheets, and have it give me a sum of the index values. Its a basic pivot, but I am running into issues trying to select the data from all of the sheets. What do I type in the range box?
Thanks for your help.