THANK YOU!!! I've been trying to figure out how to do this for years! No exaggeration. My one goal today was to finally work out how create a macro that inserts a pivot table using variable table sizes. Amazing. Thanks so much. This is a game-changer! :-)
Tried using your approach but mine has an error Run TIme error 9 which is Subscript out of Range at dataname = ActiveSheet.ListObjects(1).Name . Can you please me with the same or anyone else can help me
Hi chester. good video. tried using your approach but mine has an error Run TIme error 9 which is Subscript out of Range at dataname = ActiveSheet.ListObjects(1).Name do you know why is this so. thank you
thank you. worked for me in general, but i have a question how to make the filter work inside the pivot (i have to eliminate all items from dropdown that have 152; in them, and the list might vary) it keeps the original selection only. :(
Nice. If your filesize expanded dramatically due to many pivot tables, you can set a pt option savedata =false. Each pivot table you create, even if it's the same source, saves a copy of the data unless you toggle the savedata option OR use a data model as source. google is your friend.
Thank you chester. I want to add the pivot table to the existing sheet. I have tried to modify your code but it isn't working. My code stips at dataname = ActiveSheet.ListOpbjects(1).Name
I did exactly as you did and I am getting a run time error 1004 - reference not valid Dim dataname As String Dim newsheet As String dataname = ActiveSheet.ListObjects(1).Name
Ok, so tutorials like this restore my faith on humanity! Thank you a lot, my friend! =)
This is the solution I've been looking for for months.... Very grateful you uploaded this!!
Finally, a video which solves the basic problem of 1004 on a level I can understand. Thank You!!!
THANK YOU!!! I've been trying to figure out how to do this for years! No exaggeration. My one goal today was to finally work out how create a macro that inserts a pivot table using variable table sizes. Amazing. Thanks so much. This is a game-changer! :-)
Tried using your approach but mine has an error Run TIme error 9 which is Subscript out of Range at dataname = ActiveSheet.ListObjects(1).Name . Can you please me with the same or anyone else can help me
Hi chester. good video. tried using your approach but mine has an error Run TIme error 9 which is Subscript out of Range at dataname = ActiveSheet.ListObjects(1).Name
do you know why is this so.
thank you
Thank you Chester. The fix works perfectly!!!
Thanks so much! it worked for me and it was simple to follow.
This is exactly what I was looking for 👍, this helped a lot.
You sir, helped me solve a big issue. A nice step by step and well explained video.
Thank you so much
Thank you very much for this video, was very helpful, please can you do a video for dynamic columns as well.
I am stuck at the same thing
I need to make pivot based on dynamic columns
Please advise
thank you. worked for me in general, but i have a question how to make the filter work inside the pivot (i have to eliminate all items from dropdown that have 152; in them, and the list might vary) it keeps the original selection only. :(
Thank you so much for your thorough video! It worked perfectly for what I needed. 🙏🏼
Thank u So much Sir,
can you Please help , will this error occur every time?
Can't we fix it for everyone?
Thank you very much Mr. Chester Tugwell. It was helpful
great job! thanks chester, you really helped me out
Thank you so much chester!
Amazing tutorial. thanks a lot!!!
Hello Sir
At 8:37 on video did you right newsheet 1 or ?
Becoz mine pivot' VBA is stuck over that point.
Pls help
Worked perfectly, thank you!
Thanks ! you saved me a lot of debugging time.
Thanks bud. Is it a quick fix to put the maco in the same sheet rather than a new sheet?
Great video!
It helped me a lot- thank you
This is great! Thank you so much!
Nice. If your filesize expanded dramatically due to many pivot tables, you can set a pt option savedata =false. Each pivot table you create, even if it's the same source, saves a copy of the data unless you toggle the savedata option OR use a data model as source. google is your friend.
Perfect
Thank you awesome lesson! ❤️👍🏽
very good one!!!
really what i needed!! thanks chester
Hi , i am getting error with listobject name ... as subcript out of range .. can you help
Great! Thank You!
what if you need to take a new sheet of data and add that to the existing pivot table?
After Revenue Pivot, can not create next pivot table using the macro. Need to debug since Revenue Pivot worksheet is already exist.
thank you veeeeeery much!
Thank you chester. I want to add the pivot table to the existing sheet. I have tried to modify your code but it isn't working. My code stips at dataname = ActiveSheet.ListOpbjects(1).Name
listobjects not opbjects
Idk why, but it did not work for me. Same error of debug coming after making all the changes as in the video.
Can we change Destination to Dynamic?
I did exactly as you did and I am getting a run time error 1004 - reference not valid
Dim dataname As String
Dim newsheet As String
dataname = ActiveSheet.ListObjects(1).Name
Sheets.Add
newsheet = ActiveSheet.Name
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
dataname, Version:=6).CreatePivotTable TableDestination:=newsheet & "!R3C1", _
TableName:="PivotTable1", DefaultVersion:=6
Thanks ! Very Helpful !