Can anybody advise me on how to make a Pivot Table with multipe Excel Tabs. I have 80,000 lines of data, so I had to split it up into 2 tabs.
Thanks, Sagar
Can anybody advise me on how to make a Pivot Table with multipe Excel Tabs. I have 80,000 lines of data, so I had to split it up into 2 tabs.
Thanks, Sagar
use the pivot table wizard and use the option - 'mulitple consolidation ranges'
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks