I have an Excel sheet with multiple rows in this format:
Column A|Column B label | value --------|-------- header (merged cells) labelA |12 labelB |5 labelC |9 header (merged cells) labelA |13 labelD |8
It's basically a list of labels and values split up over multiple different sections. In reality there are 70-80 labels and all labels are used 5-10 times. I need to create an output on a separate sheet in the following format:
Column A|Column B label | Total sum --------|---------- labelA |25 labelB |5 labelC |9 labelD |8
Ideally the first sheet can be dynamically updated, with new labels reflecting immediately in the second sheet.
I'm sure I can create a macro to accomplish this, however I don't want to add macros if I do not have to. The data is not currently in a pivot table. Is there any way to accomplish this without those solutions?