Moving and comparing data

K

Kev427

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top