I have a huge data spilling in more than one sheets in excel 2003. How do i create a normal pivot table from multiple sheets?. I don't want to use " consolidation" feature of Pivot table menu.
yes
no
simple
complex
I have a huge data spilling in more than one sheets in excel 2003. How do i create a normal pivot table from multiple sheets?. I don't want to use " consolidation" feature of Pivot table menu.
Regards,
Sandeep
Take a look at http://www.contextures.com/excelfiles.html#Pivot and look for PT0007, Multiple consolidation ranges. Uses MZ Query to join multiple ranges in to a normal pivot table. Haven't tested this myself though.
Thanks!!!!
Welcome to the forum, sandeepag.
Don't open polls when you start threads, please.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks