Simple VBA Fixes for Excel PivotTable Macros

[@lopeslayer]

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

[@coolpatj]

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

[@diannejewell4410]

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

[@jiojio]

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

[@1509niks]

Thank you Chester. The fix works perfectly!!!

[@sureshnagappan762]

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

[@farazahmed1025]

Thank you very much for this video, was very helpful, please can you do a video for dynamic columns as well.

[@sunilshahzad8535]

I am stuck at the same thing I need to make pivot based on dynamic columns Please advise

[@rohitvautre3159]

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

[@mariegracealban5744]

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

[@kyttdina100]

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. :(

[@RahulSharma-bw3zg]

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

[@deejayMarks]

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

[@inuinu8004]

Amazing tutorial. thanks a lot!!!

[@Nileshkumar-ks9tw]

Thank you so much chester!

[@suvishah26]

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

[@Eivogel1985]

great job! thanks chester, you really helped me out

[@clarinkitty631]

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

[@sudhindrasukumar2605]

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

[@skpandey202]

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

[@dasrotrad]

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

[@Nileshkumar-ks9tw]

listobjects not opbjects

[@NErJeTeek]

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

[@AlexisKimbrough]

Worked perfectly, thank you!

[@ftey2000]

Thanks ! you saved me a lot of debugging time.

[@evchaboy3570]

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

[@monicathatcher7140]

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

[@jfuen3784]

Perfect

[@bloody88]

Great! Thank You!

[@salaivanamalir279]

very good one!!!

[@MrLilbill805]

This is great! Thank you so much!

[@rodericpenullar1190]

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

[@ahmedbaklka3324]

Thank you awesome lesson! ❤️👍🏽

[@anabernal5129]

thank you veeeeeery much!

[@dammitanothername]

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.

[@KhoaNguyen-fs6to]

Can we change Destination to Dynamic?

[@SuperVindvalker]

Great video! It helped me a lot- thank you

[@mastercamer]

really what i needed!! thanks chester

[@sahiljainnit]

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

[@danielalexander3640]

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

[@jayasreecarey7843]

Thanks ! Very Helpful !