Is there a way to wild card file name references in formulas to make it easier to duplicate formulas between like categories. I have data from several regions. I have the regions copy their data to a central file share with the following filename format, NE Data.xls, SE Data.xls, etc. I have formulas that refer to these files but when I update the formulas I have to update each file name ref individually as I copy the updated formulas across the region fields they are placed in. Can you wild card the beginning of the file name so when I update one set of formulas I can just copy them in each set of related region fileds and be done with it? The data is identified within each file as with a field that the formula looks at.
I think this may slow formula updates down since now the formulas will be looking at 10 files and not just one. Would it screw up my links?
I think this may slow formula updates down since now the formulas will be looking at 10 files and not just one. Would it screw up my links?