How to make file reference selectable
Posted by Dwight W. Reed, Jr. on March 12, 2001 5:10 PM
My employees fill out a summary excel worksheet of the days productivity numbers and save them under the file name Tally03-01-01.xls. I would like to write a formula where I can substitute the date in the below formula and have the Summary data change in my combined worksheet for a month. So in cell A1 I may have 03-02-01 and the formula below will change to reflect a different date and open a different file.
Any help would be appreciated.