Hi,

I am novice to excel macros and now I am with a task as follows:

I will have 2 spreadsheets say cnsdata.xlsx and machdata.xlsx. both have thousands of records and they both have a reference column UCN to match on.

I need to read thru machdata.xlsx and match the UCN record in cnsdata.xlsx (there could be more than one row with that UCN in this spreadsheet, but I need to consider only the first record) and create a record into the third spreadsheet with some info from machdata.xlsx and some from cnsdata.xlsx.

for example say machdata spreadsheet has the following in column A B C D

1001 B1 C1 D1
1002 B2 C2 D2
1003 B3 C3 D3
1004 B4 C4 D4

and say cnsdata spreadsheet has the following in column A B C D E
1001 E1 F1 G1 H1
1001 E2 F2 G2 H2
1002 E3 F3 G3 H3

based on the above, after processing data in machdata spreadsheet, I should create newdata.xlsx with columns A B C D E as

1001 B1 F1 G1 D1
1002 B2 F3 G3 D3
1003 B3 D3
1004 B4 D4

I hope I am clear enough on my requirement. any help would be appreciated.

- Basu