I would like to change the referencing in cells based on a date inputed once. The current code is:
, and I want the filename to draw reference to a cell with a date in it, to possibly look something like this:
, but can't get the filename to draw reference to the cell where the date is. Please help.
Code:
'C:\Users\Garreth\Documents\Cell Feedback Forms\Other\[Cell Feedback Form - Durward S - 07 August 2007.xls]Feedback Form'!$D$12:$G$12
Code:
'C:\Users\Garreth\Documents\Cell Feedback Forms\Other\[Cell Feedback Form - Durward S - C7.xls]Feedback Form'!$D$12:$G$12