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
Bookmarks