changing dates.

C

chesty

if i have a spreadsheet pulling in various numbers from another spreadsheet
which is named by dates i.e excel_06_14_06 is todays how do i get my
spreadsheet to update each various component by one day....

i.e cell g7 =excel_06_14_06(f6) how do i get it to udate tomorrow for
excel_06_15_06??
 
G

Gary L Brown

Dear 'chesty',
Put the new date in A1 and use the indirect function.
ie: Cell A1: 06_15_06

=INDIRECT("'"&A1&"'!F6")

will evaluate as...
='06_15_06'!F6

HTH,
 
Top