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

[Paul_Hossler]

Do I create a Pivot first then the loop to create sheets and tables?

What I've done in the past was to use VBA to create a temporary PT on a temporary WS to do all the heavy lifting and then by selecting the appropriate page fields to 'filter' the data I could create the final reports

Along the way, I created any needed 'derived' fields for parameters that were not in the source data

Delete the temporary WS and I was done

That's just one way

Sometimes I created a temporary WS with a copy of the source data and any auxiliary values to make the PT easier to use