Every day I have to put together a report. There is a master file for the report that I copy and paste, and then rename for the appropriate date in mm-dd-yy format. Is there a formula that I can save on the master file so that I can pull numbers from the previous days report? For example I copy and paste the master file, and rename it 01-05-09. The date is typed into cell F3 in the "Report" tab. What I need to do is pull the number from cell C8 in the "Swing daily sum" tab on the previous days report. Any help would be appreciated!
-
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.
Date adjustment
- Thread starter srcasm83
- Start date
Yard
Well-known Member
- Joined
- Nov 5, 2008
- Messages
- 1,929
Don't follow 100%, but you could use a built-up INDIRECT function to incorporate the file's path and then the cell value containing the date, eg:
=INDIRECT("'[TestFile "&TEXT(A2,"mm-dd-yy")&".xlsm]Sheet1'!$A$1")
where A2 contains the date.
However:
i) this only works when the source file is actually open.
ii) you'll need something more complex when you want to drag the formula down/across, since the "$A$1" part is just text.
Probably a better way of doing it if I understood your post better.
=INDIRECT("'[TestFile "&TEXT(A2,"mm-dd-yy")&".xlsm]Sheet1'!$A$1")
where A2 contains the date.
However:
i) this only works when the source file is actually open.
ii) you'll need something more complex when you want to drag the formula down/across, since the "$A$1" part is just text.
Probably a better way of doing it if I understood your post better.
Upvote
0
Similar threads
- Solved
- Question
- Question
