Merge and Sum Tables

H

HamishM

Hi,

I have two tables which get created several times per month.

I would like to be able to merge all entries in the two tables and i
there are duplicate items in Col A then sum the value in Col B

e.g

Table 1:
Supplier Weight
Tim 5
Tom 7
Brad 3

Table 2:
Supplier Weight
John 4
Dave 3
Sarah 9
Tom 2


Merged Table:
Supplier Weight
Tim 5
Tom 9
Brad 3
John 4
Dave 3
Sarah 9

I have no problem using a macro or formula.

thanks in advance,
Hamis
 
Top