changing dates.
 

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??
--
chesty

changing dates.
 

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,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"chesty" wrote:

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??
--
chesty