Hi
I have two sheets with information.
The first one contains four columns with values that need to be matched on the second sheet.
The second sheet contains five columns from were I want to move the fifth columns value to the first sheet when a match is found.
In my quest to find a solution too this I have found a macro in this thread: http://www.mrexcel.com/forum/excel-...-compare-move-data-one-worksheet-another.html
That macro have been of great us to me in correcting huge amount of data.
I cant find a macro that can do this on multiple columns and I tried to see if I could learn to make my own macro.
But I found out that I dont possess the skills to make a for me so advanced macro.
Can anyone please help me with a macro that will work on multiple columns.
I am using Excel 2010 and Win 7 Enterprise with service pack 1.
Thanks in advance
Here are examples of the data.
Sheet1
<tbody>
</tbody>
Sheet2
<tbody>
</tbody>
I have two sheets with information.
The first one contains four columns with values that need to be matched on the second sheet.
The second sheet contains five columns from were I want to move the fifth columns value to the first sheet when a match is found.
In my quest to find a solution too this I have found a macro in this thread: http://www.mrexcel.com/forum/excel-...-compare-move-data-one-worksheet-another.html
That macro have been of great us to me in correcting huge amount of data.
I cant find a macro that can do this on multiple columns and I tried to see if I could learn to make my own macro.
But I found out that I dont possess the skills to make a for me so advanced macro.
Can anyone please help me with a macro that will work on multiple columns.
I am using Excel 2010 and Win 7 Enterprise with service pack 1.
Thanks in advance
Here are examples of the data.
Sheet1
PSYS_NO | TAG | SPEC | MATERIAL | MATSPEC | SIZE | Innerdiameter (mm) |
161.1101 | P11076 | B150A | CARBON STEEL | ASTM A106-GRB | 0,50 | |
161.1101 | P11078 | B150A | CARBON STEEL | ASTM A106-GRB | 1,00 | |
161.1102 | FOS11001 | B300A | CARBON STEEL | ASTM A106-GRB | 1,00 | |
161.1102 | P11006 | B300A | CARBON STEEL | ASTM A106-GRB | 2,00 | |
161.1102 | P11007 | B300A | CARBON STEEL | ASTM A106-GRB | 2,00 | |
161.1102 | P11015 | B300A | CARBON STEEL | ASTM A106-GRB | 1,50 |
<tbody>
</tbody>
Sheet2
SPEC | MATERIAL | MATSPEC | SIZE | Innerdiameter (mm) |
B300A | CARBON STEEL | ASTM A106-GRB | 0,50 | 13,88 |
B300A | CARBON STEEL | ASTM A106-GRB | 0,75 | 18,85 |
B300A | CARBON STEEL | ASTM A106-GRB | 1,00 | 24,30 |
B300A | CARBON STEEL | ASTM A106-GRB | 1,25 | 32,46 |
B300A | CARBON STEEL | ASTM A106-GRB | 1,50 | 38,10 |
B300A | CARBON STEEL | ASTM A106-GRB | 2,00 | 49,25 |
<tbody>
</tbody>