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

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'

[vincentlao]

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

[Monica-ypyc]

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

[manodura]

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 👍🏻😊👍🏻

[annsaphone]

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

[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

[AplusSH]

Thank you so much. This helped me a lot, and may God reward you with happiness in life and afterlife.
I use huge data and each file diverse from the other but it was very smart to create a table before hitting ti pivot table in order to align all rows and columns.
Thank you again and BTW you have a sweet voice.
❤❤❤❤

[laurastreckert]

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

[giridhargiri]

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

[brendaremus]

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

[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

[bhaktivedios-gt]

Ma'am Aweome video .

I was searching it for the same from long period of time.

[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?

[omarelafia]

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

[assatopan]

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

[renzot]

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

[randomname]

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 .

[abduljawad]

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 ?

[ryansodhi]

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

[clarinkitty]

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

[caisrailansari]

How Can Make The Pivot Table Selection Range be Variable