Create a Pivot table with VBA in Excel

[@gregarayamandelbrot]

I had no idea you could do this, saving my skin. Thanks so much!

[@BarbHendersonconsulting]

Glad I could help!

[@elohan6082]

fabulous solution and code, thanks so much

[@АлександрМыскин-д1ю]

Спасибо. Макрос помог мне сегодня. Все работает отлично.

[@BarbHendersonconsulting]

пожалуйста

[@ChristinaFoodJournal]

Thank you so much!! I think i can use your code to serve part of the function i need!! this is a very important piece. It would save me an hour doing it manually. thanks a million

[@ChodeOReilly]

Thank you for this tutorial. It helped me tremendously.

[@RAEN74]

I know little so I can't critique, but I have to say you did this in what seems to be a great and simple way to perform this.

[@diwakarpandey2507]

Thanks Henderson ! It's really helpful !!!!!!!!!!!!!!!!!!!!!!

[@surangiweerakoon7447]

Thanks you so much,. Truly useful!

[@achilleasmanousakis4622]

Thank you, very useful

[@alishacrswartz]

excelchamps for the win

[@BarbHendersonconsulting]

thanks

[@4511raj]

good explanation

[@mohamadismail9768]

I am facing an error at "Set PCache". Please help.

[@damienhettiarachchi9469]

Why error message shows pivot table report will not fit on the sheet. Do you want to show as much as possible?
Need to create pivot with 24 table columns
Data sheet row count 600000

[@BarbHendersonconsulting]

I was not aware that there was a limit to the size, but I guess there is

[@damienhettiarachchi9469]

@@BarbHendersonconsulting Thanks for the reply 🤝

[@JyotiSharma-ft3en]

Hello Mam, thanks for your video. But am not able to fetch my table data, as my data table start from row 6 to column S

[@ismailismaili0071]

so cool

[@jomzrpg6312]

This does not work in Excel 2016.

[@BarbHendersonconsulting]

I created this in Excel 2016

[@CyrrilE]

@@BarbHendersonconsulting hi! I'm getting a type mismatch error along the lines re: setting the PCache rows.

[@anjanikumar2708]

Hi, this code is not running,

[@BarbHendersonconsulting]

see my other reply

[@anjanikumar2708]

It shows error in PCache

[@BarbHendersonconsulting]

try adding Dim pCache As PivotCache
Dim pTable As PivotTable