Simple pivot table using an excel macro

In this video I show you how to use a simple macro to create a pivot table and quickly format it. Then how to slightly edit the VBA code in-order to make the macro work for a table with any number of rows so the table can have a dynamic range.
-------------------------------------------------------------------------
#exceltutorials #excelmacros #excelpivottables
SUBSCRIBE: goo.gl/c46YPs
VIDEO INFO: These data are related to my PhD research.
-------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
- Another video where I use a macro: 'How to use powerpoint to compare NAME plots with concentrations'
• Using powerpoint to in...
- 'How to group columns in a pivot table' • How to group columns i...
- 'How to link an ActiveX control textbox to a cell in excel' • How to link an ActiveX...

[@manodura8132]

Thank you Karina so much for this videotutorial. Exactly the information I have not seen anywhere and of great value to my project. And your teaching style/ audiovisuals so clear. Highly recommended 👍🏻😊👍🏻

[@YoutubeYTG]

Hi Karina, Thanks for your tutorial. Though I have followed all your instructions I am getting error 1004 while running the Macro. Could you please suggest a way out?

[@vincentlao9498]

This is the only instructional video that solved my frustrations in creating a pivot table using macro. Thank you Karina :-)

[@ambarilhamchannel]

Thank you for the video. This inspired me so much to work more efficient by using Macro without thinking to much formulas.. I still have a question. How if I don't change the table format into table, can dynamic pivot table still run? Because I have inconsistent formula in calculation that can be problem If I change it into table which has consistent formula for each column.. Thank you for your explanation

[@annsaphone]

This tutorial is so simple and it just works! Thanks Karina!

[@SALMAN.KHAN.MF003]

My question is if we want to run Macros with same DATA but new sheet it will not work i believe. Could make me understand on that

[@laurastreckert7502]

THANK YOU! This is exactly what I was searching for and it's brilliant. A million thumbs up!!

[@abduljawad1318]

If i had to use some complex scenario such as using pivot analyze and group selection thing in it ? Can you help me out in it ?

[@caisrailansari2417]

How Can Make The Pivot Table Selection Range be Variable

[@AshleighJackson-r8s]

Hi Karina! I am creating a macros for pivot table and keep getting the Run-time error "5": invalid procedure call or argument however I have defined my worksheet and my table: Range("A1").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Application.CutCopyMode = False ActiveSheet.ListObjects.Add(xlSrcRange, Selection, , xlYes).Name = _ "Table7" Range("Table7[#All]").Select Application.CutCopyMode = False ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "Table7", Version:=8).CreatePivotTable TableDestination:="Personnel Pivot!R3C1", _ TableName:="PivotTable17", DefaultVersion:=8 Sheets("Personnel Pivot").Select Cells(3, 1).Select With ActiveSheet.PivotTables("PivotTable17") .ColumnGrand = True .HasAutoFormat = True .DisplayErrorString = False .DisplayNullString = True .EnableDrilldown = True .ErrorString = "" .MergeLabels = False Can you please help me with this?? thank you!

[@Monica-yp6yc]

finally! thank you for explaining this, ive done probably close to a dozen other tutorials and none of them worked. your video did the trick, i recorded one macro that produces multiple pivot tables in the same workbook. and i can run it w no problems! thanks again, greatly appreciate it

[@assatopan6918]

Thank you, this is so useful for my daily report making...🤩

[@Rakesh5505]

This is not a dynamic..

[@jahankhan7238]

THATS was so brilliant its works but sometimes it gives me an error Karina, What should I do???

[@alagar_skillstation]

Very useful. thankyou :)

[@ryansodhi1815]

Hi Karina I have a big data set of 1million rows Can I select the whole excel sheet and then do this without facing any issues? I am not seeing range in VBA code it's coming as source data for me

[@gracege3836]

hi Karina, i have trouble at line 5, it says run-time error '1004': A table can't overlap another table. Do you know how to solve it please? Thanks!

[@clarinkitty631]

Mam, once you opened the copy file whether did the pivot go? I did try the same but pivot is there and unable to run the macro

[@giridhargiri998]

this was the exact thing i was looking for. thank you karina keep posting knowledgeable video dont stop.

[@wagsbass]

I love you good madam. After wasting an entire weekend trying to get this to work, I stumbled on your tutorial. Thank you very much

[@fitriishun]

Hi, loved the explanation. However, when i tried this method, I keep on getting error on pivot table not appearing after i run the macro. help :(

[@bhaktivedios-g9t]

Ma'am Aweome video . I was searching it for the same from long period of time.

[@iamsingle001]

Thanks ka.. working perfectly

[@brendaremus7184]

Thank you! This video is what I have been looking forever for.

[@renzot2391]

Thank you Karina!!!! very nice and helpful video!

[@Sagarsingh657]

Thank you this was really helpful

[@randomname9758]

This is brilliant ! This is going to speed up so many things in my monthly reports. what would happen if you make a mistake in your macro while recording is the erase or backspace function ? How long should a macro be , some of the steps I'm thinking of automating would have over 300 steps ? Thank you .

[@karinaadcock]

A macro records everything you do, so if you make a mistake, you can either re-record the macro from the beginning, or edit the macros code after you have finished and delete the part you don't want. The size of macros are limited to 64kb which I think is about 1000 to 2000 lines.

[@suhasdabre7206]

Thanks fr this video....much appreciated😊

[@omarelafia1175]

thank you so much for this trick, it is the easiest

[@Pegasus_International]

My pivot comes without row labels plz assist

[@pankajdas9178]

Thank u mam

[@karthika5573]

Great👏

[@sheshanshezhad6802]

great