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

[p45cal]

And do you think it will be easier to just pivot the data then put them in the tables rather than use formulas? I noticed that one formula significantly slowed down your code

Pivot what data?
What formulae?