Sorry in advance for having to write another paragraph to explain. I have to upload a large # of files (400-2500) once those files are finished to a website. Before uploading I create a screenshot printout of all the files names so I can check them off as I go. Once that is done, I have to go through each file name in the printout (Ex: 3 Bay - 99,87,55,90 - Str xxx -AA 01.2012.file type) and find them in the excel file based on the number following STR since it is the only unique piece in the series. I have a folder with all of the files still in it, so it is theoretically possible to sort them by the number following the str but I'm not capable of doing that. As far as updating excel, I have to first sort by category to narrow down the ones that I won't need (there are 5) and then find each individual one to initial from the remaining ones. The number following str is the number that is found in column E and each row down would obviously be a different file.