Hi Guys
Apologies I was not able to find what I was looking for in the forum.
I have 3 columns.
Col A = ID (10,000 items)
Col B = unique ref number (10,000 items)
Col C = ref list number to check against (1700 items)
What I would like to do is use a vba macro to check each item in Col B against the item list in Col C.
If no match is found for Col B in Col C, then copy the value from Col B and the adjacent value from Col A to a new columns (or a new sheet)
Apologies I was not able to find what I was looking for in the forum.
I have 3 columns.
Col A = ID (10,000 items)
Col B = unique ref number (10,000 items)
Col C = ref list number to check against (1700 items)
What I would like to do is use a vba macro to check each item in Col B against the item list in Col C.
If no match is found for Col B in Col C, then copy the value from Col B and the adjacent value from Col A to a new columns (or a new sheet)