I'm a recent addition to the forum and am having a tough time trying to figure out how to deal with a grading spreadsheet that will pull in a few hundred serial numbered files with a couple hundred references in each.
Is there a way to pull files in that are in the same directory without the likelihood that Excel will add a path against my will? I will be sharing the spreadsheet with others who will put the serial numbered files in the directory, so I can't have the risk the user will be stranded. Does anyone have ideas? Thanks so much!!
Bookmarks