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

[jazz2409]

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

Do you have a sample workbook of this that I can study?

[p45cal]

I'm aiming to produce two solutions, one with pivot tables and one with just formulae. This will allow comparison and if they're the same all well and good, you'll have a choice. If they're different then some detective work will be needed.

[jazz2409]

If OB AHT = "" or 0, the value of Full AHT is IB AHT/IB Tasks
Otherwise, the formula is IB AHT + (OB AHT *(OB TASKS/IB TASKS))