Hi,
I'm new to the board, but i have used these pages as a valuable resource for many years, so thank you firstly!
My problem is,
I have one ws with about 1500 lines of codes (in one column), some are repeated, some are unique.
In the second ws, i have 75,000 individual codes in one column and a descriptive name in the next colum.
What i would like to do is compare the codes that exist in ws1 to the codes that exist in ws2 and then when two codes match, the description is placed next to the code in ws1 in the next column. This would be for the whole work sheet.
For example in my first ws i have
DH86
UE92
TY34
In the second work sheet i have
UI23 Stock movement
DH86 Stock transfer
HU23 Finance Agreement
TY34 Repeat Transaction
So if i take the code DH86 in ws1 it scans through the code column in ws2 until it finds a match, it then takes the description of the match and places next to the code in ws1.
I hope this is clear enough, and it is possible to do, thanks for the help!
I'm new to the board, but i have used these pages as a valuable resource for many years, so thank you firstly!
My problem is,
I have one ws with about 1500 lines of codes (in one column), some are repeated, some are unique.
In the second ws, i have 75,000 individual codes in one column and a descriptive name in the next colum.
What i would like to do is compare the codes that exist in ws1 to the codes that exist in ws2 and then when two codes match, the description is placed next to the code in ws1 in the next column. This would be for the whole work sheet.
For example in my first ws i have
DH86
UE92
TY34
In the second work sheet i have
UI23 Stock movement
DH86 Stock transfer
HU23 Finance Agreement
TY34 Repeat Transaction
So if i take the code DH86 in ws1 it scans through the code column in ws2 until it finds a match, it then takes the description of the match and places next to the code in ws1.
I hope this is clear enough, and it is possible to do, thanks for the help!