I have a master spreadsheet that is linked to two other "data" spreadsheets. These two data spreadsheets change daily, and I'll name them based on what day it is (ppr101002.xls and iva101002.xls for example). My master spreadsheet summarizes this data, but I have to change formulas every day so that it is pointing to the most recent data spreadsheets (change ppr101002 to ppr101102 for example). Is there a way to automate this? Thanks in advance...
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Formula that references worksheet filename/tab?
- Thread starter drewben
- Start date
Similar threads
- Question
