Excel - Compare 2 Tables

[lindasoph]

Two excel spreadsheets:
tbl1 tbl2

SSN NAME AMT SSN NAME AMT
123-45-6789 JOE 25.00 123-45-6789 JOE 25.00
123-45-6790 SUE 50.00 123-45-6700 JASON 80.00
333-45-6700 CHRIS 10.00

Need to consolidate the two spreadsheets into one. If a record exists based off SSN in tbl1 and tbl2 I want to retain the record in tbl1 and add AMT from tbl1 & tb12(tbl1AMT=tbl1AMT + tbl2AMT) . If a record from tbl2 doesn't exist in tb11 I want to write that record into tbl1.
What is the easiest way to do this? I thought the drop down menu in Excel [Data], [Consolidate]...... would work for me but have been unable to due to: "Consolidation reference is not valid".

Thanks!

 

[chemebabak]

Easy,

1. Select a cell outside of the tables
2. from consolidate, add each table as its own reference
3. Select option use labels in top row and left column

But it is better that you use a pivot table.