Pivot for multiple sheets

amolvijay

Board Regular
Joined
Nov 13, 2012
Messages
82
Dear Experts,

Need your help.

I have a excel sheet with very huge data. Data is scattered over multiple tabs. Data structure is same on all the tabs. I need to create a single pivot table for all tabs together. I tried for MS Query, it's not working for some strange reason, Syntax Error.
I tried Alt+D option for pivot wizard, it's having its own limitations, it's not allowing me to multiple columns as category.
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Watch MrExcel Video

Forum statistics

Threads
1,119,257
Messages
5,577,016
Members
412,761
Latest member
McCrab
Top