Got a stump of a question. Is there a way to search for files in the folder as shown in the attachment based off column A using VBA and either highlight the cell to indicate that that file exists or copy to a new directory? To give you an idea, I am assuming 98% of these files don't exist but I have over 9000 to check through.
As you can see, file names have an underscore prior to the order number displayed.
As you can see, file names have an underscore prior to the order number displayed.