I need a way to find a filename path for a large amount of files so that I can link them.
I have a spreadsheet that has about 5000 "Lot Numbers" They are 7 digit numbers. I have a folder, that has some sub folders, which contain PDF files. The Main folder, will call it year folder, contains subfolders called, 2013, 2012, 2011, etc. Within these folders are pdf's that are named, USUALLY with the Lot Number first, then there are additional alpha/numeric characters to represent other data. I'd like to know how I can find out the path of the file name and put it in my spreadsheet next to the Lot Number. I suppose if there was a way to dump all the file names into a spreadsheet I could do a VLOOKUP or something...