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

[jazz2409]

Your formulae don't take into account Lob and SubLob!

Sorry I forgot to indicate that in my actual workbook, the first table is always the overall per LOB that's why the workbook I sent with a table that has formula doesn't take the LOB and Sub LOB into consideration.

In a bid to shorten the formulae, did you know that you can set the whole sheet to show zeroes as blanks in Options? (untick the box at Options|Advanced|Display Options for this worksheet|Show a zero in cells that have zero value).

Sorry I am really new to this, I am not aware that can be done.. But thank you I learned something new

This affects ALL the cells on that sheet. Code can do it (ActiveWindow.DisplayZeros = False). Can we use it?

Yes.

[There is another way using cell formatting where we could format all cells in a table to hide zero values - up to you]

Whichever you think is best. I really have no other idea besides the =""