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
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Watch MrExcel Video

Forum statistics

Threads
1,118,047
Messages
5,569,864
Members
412,298
Latest member
dietitiann
Top