Creating Multiple Tables Using Loop in VBA. I still want to add new sheets and add

[jazz2409]

Hmm just please correct me if my understanding is wrong.

The Set pf = .PageFields("Tenure") part selects the specific pagefield to be filtered and then

For Each pit In pf.PivotItems 'loops through everything that's in the array
pf.CurrentPage = pit.Name 'selects specific item inside the array
With .TableRange1 'creates table
.Copy


That's what I understood