Merge two similar sheets into a 3rd one where each record appears once & amounts summedup

In a single workbook I have Sheet1 and Sheet2 which contain lists of customers (with same fields/columns) but containing different data records, like this:

Sheet1
-------
CustId Name Amount
------ ------ ---------
1344 CustA 1,200
1344 CustB 1,115
4015 CustC 2,577
6044 CustE 1,920
7415 CustF 2,770


Sheet2
-------
CustId Name Amount
------ ----- ---------
1344 CustA 1,780
2755 CustD 3,225
4015 CustC 1,950
4015 CustC 5,540


Using Excel VBA, I would like to merge the above 2 sheets into a third one (different sheet) where each customer (from both sheets) will appear in a single record and the total of his/her amounts

I have attached an excel sheet as well for your better understanding.

Please help.

John Louck

This is a relatively easy task to do in Access if you have the inclination and the software. It is four queries based upon the two tables. The resulting query can then be exported to Excel for further analysis. See the attached Access file.