Dears,
I have the following data from workbook1:
<tbody>
</tbody>
In worksheet2 (another excel file) , i have the following format:
<tbody>
</tbody>
What i need, is a macro that match the values for each of "engine,model,card,ID" & LocationID which are available under "Important" and "LocationID" columns from workbook 1 with their respective values in Workbook 2 to get the "Alias".
<tbody>
</tbody>
I have the following data from workbook1:
Don't care | Don't Care | Important | LocationID | |
x | x | engine=0,model=14,slot=don't care,card=3,ID=4 | Germany_1 | |
x | x | engine=0,model=14,slot=don't care,card=2,ID=4 | Germany_1 | |
x | x | engine=0,model=14,slot=don't care,card=2,ID=10 | Japan_2 | |
x | x | engine=0,model=14,slot=don't care,card=2,ID=10 | Germany_2 |
<tbody>
</tbody>
In worksheet2 (another excel file) , i have the following format:
LocationID | engine | model | Card | ID | Name | Alias |
Germany_1 | 0 | 14 | 3 | 4 | y | 66666 |
Germany_1 | 0 | 14 | 2 | 4 | x | 7777 |
Japan_2 | 0 | 14 | 2 | 10 | z | 8888 |
Germany_2 | 0 | 14 | 2 | 10 | u | 9999 |
<tbody>
</tbody>
What i need, is a macro that match the values for each of "engine,model,card,ID" & LocationID which are available under "Important" and "LocationID" columns from workbook 1 with their respective values in Workbook 2 to get the "Alias".
<tbody>
</tbody>