I have two excel 2003 spreadsheets in one workbook that need to be consolidated. I think a macro approach is likely to be the best option, though I'm certainly not well-educated enough to be sure.

Sheet1 contains a single row per customer (with columns A-X), while Sheet2 contains multiple rows per customer (with columns A-G) I need to add data to the end of each row (column H) in Sheet2 with the data contained in Sheet1.

If the cell in column A of Sheet1 matches any cell in column A of Sheet2, then the information from Sheet1 should be pasted onto Sheet2 at that row. Rows from Sheet1 that did not get copied can be ignored. Then the rows from Sheet2 which did not recieve Sheet1 data can be deleted.

For example:

Sheet1
Cust# B C D ... X
1 8 9 0
3 b n m

Sheet2
Cust# B C D E F G ...
1 q w e r t y
1 q w e r t 2
1 q w e r t 3
1 q w e r t 4
2 q w e r t y

New Sheet2
Cust# B C D E F G H I J K L ...
1 q w e r t y 8 9 0
1 q w e r t 2 8 9 0
1 q w e r t 3 8 9 0
1 q w e r t 4 8 9 0


This is my first time posting here, so I probably could explain this better, with specific questions. Let me know how to make myself more clear.