Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing and moving unsorted data in Excel | Excel Discussion (Misc queries) | |||
Moving averages in Excel | Excel Discussion (Misc queries) | |||
How to sort/update large excel db | Excel Discussion (Misc queries) |