Thread
:
changing dates.
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Gary L Brown
Posts: n/a
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
Reply With Quote