Sheet 1 Sheet 2
Sheet 3

a b a b
a b
12 190 10 220
34 340
34 180 23 190
10 310
10 90 34 160
12 280
4 60 12 90
23 190
11 80
11 80

4 60

What I'm looking for is the result in sheet 3, I need column b to be the sum
of column b in sheets 1 and 2 based on the number in column a being the same,
then sorting based on column b, and obviously if the number in column a does
not occur twice then it is still added in sheet 3 with its original column b
value.
Tough to explain, but if I look at the number 12 in sheet 1 column a, I look
for another number 12 in sheet 2 column a, if there is one there, then I add
the two corresponding values in column b, and put the result in sheet 3, and
sort.

Anyone have some ideas, Please help.

Thanks

Darcy