Moving and comparing data
 

Hi

I have two columns of data - the first column contains a list of part
numbers (Eg: AB100, AB101, AB101/2) and the second contains a filepath to an
image for each part number (Eg: D:\Images\ab-100.jpg). Some products use the
same image, but different part numbers (An example would be a screwdriver
which comes in different lengths SDD8, SDD10 - two different lengths but the
same style, hence only one image). Hopefully this isn't coming across as
patronising, I'm just trying to make everything clear! :-)

What I am trying to do, is for every part number see if it has a
corresponding image in the second column. If this is true, then to move the
filepath to the relative part number in the corresponding row in the table

There are approximately 6000 part numbers and 1932 images, so not an easy
manual task!

Thanks in advance for any assistance you can provide