Creating pivot tables via macro - is there a simple way?

Hi, I need your help again. I have a file where we need to create multiple pivot tables and I am trying to automate it by recording a macro. It works when I record, but when I run it I either get all pivot tables showing with the same settings as as the last pivot I recorded or I get invalid procedure, call or argument. I tried to debut but don't really understand what I'm seeing.

Is there a straight forward way to do pivot tables in a macro where I can tell it what sheet/range to pivot and what should be in the rows, columns, filters, and values boxes for the table?

I'm still new and fumbling, so please break it down for me in as layman-ish terms as possible so I can learn. Many thanks.

So here are two pivots I've managed to record out of about 10. Maybe something in the code will pop out at you.

Please Login or Register  to view this content.

You might start here...https://excelchamps.com/blog/vba-to-create-pivot-table/