| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Pivot shart referring to multiple sheets
Hi,
I have 80000 rows of data that I had to split over two sheets because of the line restrictions. Is there a way that I can build one pivot table referring to both sheets? The two sheets are build in the exact same way. Thanks a lot. Kanga |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
| Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
| Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
| Pivot Table-Using Multiple SS's or Ranges? | Excel Discussion (Misc queries) | |||
| Multiple sheets selected | Excel Discussion (Misc queries) | |||
Linear Mode
