Dears,
I have the following data from workbook1:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Don't care[/TD]
[TD]Don't Care[/TD]
[TD]Important[/TD]
[TD]LocationID[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD]x[/TD]
[TD]engine=0,model=14,slot=don't care,card=3,ID=4[/TD]
[TD]Germany_1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD]x[/TD]
[TD]engine=0,model=14,slot=don't care,card=2,ID=4[/TD]
[TD]Germany_1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD]x[/TD]
[TD]engine=0,model=14,slot=don't care,card=2,ID=10[/TD]
[TD]Japan_2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD]x[/TD]
[TD]engine=0,model=14,slot=don't care,card=2,ID=10[/TD]
[TD]Germany_2[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
In worksheet2 (another excel file) , i have the following format:
[TABLE="width: 500"]
<tbody>[TR]
[TD]LocationID[/TD]
[TD]engine[/TD]
[TD]model[/TD]
[TD]Card[/TD]
[TD]ID[/TD]
[TD]Name[/TD]
[TD]Alias[/TD]
[/TR]
[TR]
[TD]Germany_1[/TD]
[TD]0[/TD]
[TD]14[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]y[/TD]
[TD]66666[/TD]
[/TR]
[TR]
[TD]Germany_1[/TD]
[TD]0[/TD]
[TD]14[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]x[/TD]
[TD]7777[/TD]
[/TR]
[TR]
[TD]Japan_2[/TD]
[TD]0[/TD]
[TD]14[/TD]
[TD]2[/TD]
[TD]10[/TD]
[TD]z[/TD]
[TD]8888[/TD]
[/TR]
[TR]
[TD]Germany_2[/TD]
[TD]0[/TD]
[TD]14[/TD]
[TD]2[/TD]
[TD]10[/TD]
[TD]u[/TD]
[TD]9999[/TD]
[/TR]
</tbody>[/TABLE]
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".
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I have the following data from workbook1:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Don't care[/TD]
[TD]Don't Care[/TD]
[TD]Important[/TD]
[TD]LocationID[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD]x[/TD]
[TD]engine=0,model=14,slot=don't care,card=3,ID=4[/TD]
[TD]Germany_1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD]x[/TD]
[TD]engine=0,model=14,slot=don't care,card=2,ID=4[/TD]
[TD]Germany_1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD]x[/TD]
[TD]engine=0,model=14,slot=don't care,card=2,ID=10[/TD]
[TD]Japan_2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD]x[/TD]
[TD]engine=0,model=14,slot=don't care,card=2,ID=10[/TD]
[TD]Germany_2[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
In worksheet2 (another excel file) , i have the following format:
[TABLE="width: 500"]
<tbody>[TR]
[TD]LocationID[/TD]
[TD]engine[/TD]
[TD]model[/TD]
[TD]Card[/TD]
[TD]ID[/TD]
[TD]Name[/TD]
[TD]Alias[/TD]
[/TR]
[TR]
[TD]Germany_1[/TD]
[TD]0[/TD]
[TD]14[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]y[/TD]
[TD]66666[/TD]
[/TR]
[TR]
[TD]Germany_1[/TD]
[TD]0[/TD]
[TD]14[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]x[/TD]
[TD]7777[/TD]
[/TR]
[TR]
[TD]Japan_2[/TD]
[TD]0[/TD]
[TD]14[/TD]
[TD]2[/TD]
[TD]10[/TD]
[TD]z[/TD]
[TD]8888[/TD]
[/TR]
[TR]
[TD]Germany_2[/TD]
[TD]0[/TD]
[TD]14[/TD]
[TD]2[/TD]
[TD]10[/TD]
[TD]u[/TD]
[TD]9999[/TD]
[/TR]
</tbody>[/TABLE]
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".
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]