Can I use VBA to create a combined pivot table across data from multiple sheets?
I have a workbook with a blank sheet 1, and then followed by 8-10 working sheets. All the working sheets have the same headers, the only difference is the month.
The data source is from A1:T9999 on each working sheet.
Can I also put the pivot table on Sheet 1's Cell Q1?
Not sure what version of Excel (16.72?) you are using.
Assuming that it might be Excel 2016 or newer, would you consider using Get & Transform (a.k.a. Power Query) to combine Excel tables on the monthly sheets and then producing a pivot table from there?
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
I think that 16.72 is a Mac version: https://learn.microsoft.com/en-us/of...office-for-mac
If so, the OP should add 'Mac' to their forum profile.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
@AliGW, Thank You for the information.
@Webcam723, I see that you have updated your profile, although you didn't specify Mac.
Do you have Power Query and would you want to try to use that as opposed to VBA to produce a pivot table?
If so please attach a small sample of your workbook to your next post.
Information about attachments is given in the "HOW TO ATTACH YOUR SAMPLE WORKBOOK" banner at the top of the page.
Let us know if you have any questions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
webcam723 
Register To Reply
Bookmarks