how to create pivot tables for all existing tables dynamically using VBA

[prafvik]

suppose I have three data tables in same worksheet, I need to create their corresponding Pivot tables
Is it possible
EX:- tbl1 -> Pivtble1
tbl -> Pivtble2
etc
also I am notsure what is table range and table name

can I create pivot table for such scenario using VBA ?

Thnks

 

[Rijnsent]

Hi Prafvik,
you could start with a loop like this: https://www.thespreadsheetguru.com/...ugh-all-tables-in-excel-workbook-or-worksheet -> it basically loops through all the tables in your workbook. You'd need to write a bit of code to create the pivot tables, e.g. like so: https://www.mrexcel.com/forum/excel-questions/1060556-creating-pivot-table-vba.html
Hope that helps. If you get stuck, don't hesitate to post the code you created here.
Koen