veloscaraptor:
So I have a spreadsheet that contains student participant information (first name, last name, etc) paired with the newly created Participant ID numbers (and new file names based on these IDs). I also have files containing student names. What I need to do is rename each file by matching student names (which are in both the filename and the spreadsheet) and retrieving/using the correct filename from the spreadsheet to rename the data file (a PDF).
Well, based on my best guess of your workflow:
I have built the following Macro as an example of how you might do this:
It is probably not exactly what you want/need, but I think it should help you get started. If you have any specific questions about the macro, just ask.