How to use VBA LOOP to sum categories into a Cell

I solved with a simple pivot table if you like.

VBA

Please Login or Register  to view this content.

@jindon thank you for your solution!

@jindon is there a way to match the office names, and if the office name does not appear then skip to next office? i have uploaded your WB on have illustrated on sheet4

I'm not with my pc at the moment.

I will respond when I get back.

Change to

Please Login or Register  to view this content.

Note : Office 1 will not show due to "Office1" vs "Office 1", missing a sapce before 1, should be identical.

@jindon Thank you for all your help! Last question I have when you get a moment. How do I change your second code if my data starts in a different range, say "Office names" started in $A8 and "Totals" started in $H8, these include headers so the actual raw data would be in $A9 and $H9

Fully depends on other rows/columns, so need to see your exact data layouts and you should mention this in your first post.

@jindon uploaded a WB, please don't mind the misc data, it is part of my data just cant display certain stuff. The only difference is just the position of the rows / coulumns

Only if you have row 7 blank in sheet2,

Please Login or Register  to view this content.