How do I select multiple worksheets to form one pivot?
How do I select multiple worksheets to form one pivot?
Best to have all the data on one sheet.
If you must go down the route of data on different sheets then you would need a MS query as per the example from this site
http://www.contextures.com/excelfiles.html#Pivot under the heading
VBA NoobPT0007 - Multiple Consolidation Ranges
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks