SpaaamCatcher
Technical User
Hi, there. I have a series of spreadsheets which I am linking to and summarizing in another workbook; all of these files are in the same folder. I would like to be able to replicate this folder for each pay period and automatically have the summary spreadsheet look in its current directory for the files/fields to which it is linked.
I've tested this in clean sheets and I thought I knew how to make it work, but I can't seem to get it right in this pre-existing file. It keeps looking in its previous directory...HELP! It seems simple-I know one of you has this on the top of your head...
Jamie
I've tested this in clean sheets and I thought I knew how to make it work, but I can't seem to get it right in this pre-existing file. It keeps looking in its previous directory...HELP! It seems simple-I know one of you has this on the top of your head...
Jamie