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

[jazz2409]

Give me some time… I'm not full-time on this.

First of all I would like to apologize, I didn't mean to make you feel like I'm hurrying you.. I was just trying to analyze as well

While trying to implement the above (Full AHT2 in the pic) I got this as opposed to the original Full AHT in the pic.

Hopefully Full AHT2 is correct; can you confirm?
2020-01-13_190103.jpg

edit post posting:
Now I'm getting the feeling you meant to say:
If OB AHT = "" or 0, the value of Full AHT is IB AHT/IB Tasks
?

That formula is correct.

1. While creating the 'Overall' table at the top of each Lob sheet I note that the Start time (SOO column on the Database sheet) is the same for each LOB - will that ALWAYS be the case? (I'm trying to avoid looking for the latest time in a given LOB.)

2. The remaining tables are those listed in the Sub LOB for each LOB on the Database sheet; will there ever be additional Sub LOBs in the Consolidated sheet that aren't listed in the Database sheet?

3. While thinking about that, will there ever be LOBs on the Consolidated sheet that aren't in the Database sheet?

(Hopefully, you'll tell me that the Database sheet is created from the data on the Consolidated sheet and that ALL the data on the Consolidated sheet is used in creating the data in the Database sheet)

1. No, the overall table's SOO is always the SOO of the first sub LOB indicated per main LOB. Or maybe we can just add another Sub LOB saying Overall so it will be easier as we will still use the code that you wrote above. Anyway I will also put a column for headcount for each LOB so I think I'll just put another Sub LOB saying Overall
2. Yes
3. No