Hi is there a way to create a pivot table with data from multiple tabs? I am doing my taxes and I exported all my business transactions into an excel, but it has 4 different tabs as I have 4 different accounts. I created a data/drop down to categorize them on each tab. So now I want to aggregate all the categories (e.g. promotion, car, supplies, etc.) into one master summary. But not sure if I can create one master pivot table from 4 different tabs.
Help!
Thanks
Hi degross,
In older versions of excel (like 2003) you have a chance. See:
https://www.techbout.com/pivot-table...rksheets-4974/
I remember this is somewhat limited in all the things you can do and I'd simply copy and paste the data to a single table on a 5th sheet, but give the link a try.
Hope this helps.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks