Simple VBA Fixes for Excel PivotTable Macros 

This is the solution I've been looking for for months.... Very grateful you uploaded this!!

Ok, so tutorials like this restore my faith on humanity! Thank you a lot, my friend! =)

Finally, a video which solves the basic problem of 1004 on a level I can understand. Thank You!!!

Thank you so much for your thorough video! It worked perfectly for what I needed. 🙏🏼

Thank you very much Mr. Chester Tugwell. It was helpful

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! :-)

Thanks so much! it worked for me and it was simple to follow.

Worked perfectly, thank you!

Great video! It helped me a lot- thank you

Thank you Chester. The fix works perfectly!!!

This is great! Thank you so much!

really what i needed!! thanks chester

You sir, helped me solve a big issue. A nice step by step and well explained video. Thank you so much

great job! thanks chester, you really helped me out

Thank you awesome lesson! ❤️👍🏽

Thanks ! you saved me a lot of debugging time.

Thank you so much chester!

Amazing tutorial. thanks a lot!!!

This is exactly what I was looking for 👍, this helped a lot.

Great! Thank You!

Thanks ! Very Helpful !

thank you veeeeeery much!

very good one!!!

Perfect

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 very much for this video, was very helpful, please can you do a video for dynamic columns as well.

Thanks bud. Is it a quick fix to put the maco in the same sheet rather than a new sheet?

Thank u So much Sir, can you Please help , will this error occur every time? Can't we fix it for everyone?

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

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.

what if you need to take a new sheet of data and add that to the existing pivot table?

Hi , i am getting error with listobject name ... as subcript out of range .. can you help

Can we change Destination to Dynamic?

Hello Sir At 8:37 on video did you right newsheet 1 or ? Becoz mine pivot' VBA is stuck over that point. Pls help

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

After Revenue Pivot, can not create next pivot table using the macro. Need to debug since Revenue Pivot worksheet is already exist.

Idk why, but it did not work for me. Same error of debug coming after making all the changes as in the video.

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