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
Bookmarks