Questions with Macro... Using Excel 2003

[excelnoob78]

Hello everyone, and thanks for all the help.. i am an excel newbie so pls forgive me if i dont use correct verbiage.

I have a excel list with about 26k rows for example (they are part numbers for random consumer items):

IBSS434816N
IBSVALH3037N10
IMP1525
IMP4020
JAGVW3036X

~ I need to match these 26k item part numbers with a file list of about 60,000 pictures of items on my computer: C:\Users\Joseph\Desktop\WORK

...i also need to separate my 26k from the 60k and put them in a new folder...C:\Users\Joseph\Desktop\WORK\26k

HOWEVER, the item pictures in the 60k file list in my computer are a little different compared the part numbers... it has underscores (some with 2 underscores and some with 3) and random numbers at the end.

IBSS434816N_3_4.JPG
IBSVALH3037N10_1_2_3.JPG
IMP15251123.JPG
IMP402011123.JPG
JAGW4046X_1_3.JPG

I spoke with someone earlier and recommended me using a macro but with absolutely no experience with macro, only very basic excel, I look to you guys!!! thanks!!!

 

[kpark91]

So... I know how it should be done but I dunno what needs to be done.

Could you elaborate on what should be where? and possibly give examples?

Moreover, are there any repeated part numbers' pictures?

 

[excelnoob78]

thanks kpark for the quick response!

I have 60k picture files on my computer C:\Users\Joseph\Desktop\WORK

Out of these 60k picture files i need to extract ONLY the 26k part numbers on the excel list to a NEW folder...C:\Users\Joseph\Desktop\WORK\26k


there are no repeat part numbers...