How do I link data in multiple sheets to 1 pivot table in the same workbook?

ericaindallas

New Member
Joined
Aug 20, 2009
Messages
45
I have four worksheets in the same workbook and I would like to create one pivot table that includes the data from the four worksheets.

Among the four worksheets the field headers are inconsistent and some worksheets have more fields than others. I know pivot tables enough to know the field name must be consistent, so I can change that.

Just uncertain how to get multiple data sources in one pivot table in the same workbook.

Thanks

Erica
 

Forum statistics

Threads
1,082,478
Messages
5,365,783
Members
400,850
Latest member
Raj_Jpr

Some videos you may like

This Week's Hot Topics

Top