Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell reference
Here is the formula =+'19'!$F$17 where '19' is referencing a tab name
representing the day of the month. I have multiple formulas in the spreadsheet referencing the current day of the month sheet ie 19 in this case. How do I embed a cell reference into the formula so that I can just change one cell from 19 to 20 to 21,etc rather than going to each formula and changing it to a 20, 21, etc. -- Libby |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell reference
Hi Libby,
You don't need the + sign. Make sure you have ToolsOptionsTransitionall items unchecked, unless you explicitly need them Look in HELP for the INDIRECT() function Post again in this thread if you can't get it done -- Kind regards, Niek Otten Microsoft MVP - Excel "Libby" wrote in message ... | Here is the formula =+'19'!$F$17 where '19' is referencing a tab name | representing the day of the month. I have multiple formulas in the | spreadsheet referencing the current day of the month sheet ie 19 in this | case. How do I embed a cell reference into the formula so that I can just | change one cell from 19 to 20 to 21,etc rather than going to each formula and | changing it to a 20, 21, etc. | -- | Libby |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell reference
The current formula works as is. I'm trying to modify the current formula so
that I don't have to munually change all of the 19's to 20's tomorrow, then to 21's the next day, then to 22's, etc. -- Libby "Libby" wrote: Here is the formula =+'19'!$F$17 where '19' is referencing a tab name representing the day of the month. I have multiple formulas in the spreadsheet referencing the current day of the month sheet ie 19 in this case. How do I embed a cell reference into the formula so that I can just change one cell from 19 to 20 to 21,etc rather than going to each formula and changing it to a 20, 21, etc. -- Libby |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell reference
=INDIRECT("'"&A1&"'!$F$17") if you want to put your 19 in A1, or
=INDIRECT("'"&DAY(TODAY())&"'!$F$17") if you want it to change automatically. As there are no spaces in the sheet name, you could in fact get away without the single quotes around the '19', so the formula could be simplified further. -- David Biddulph "Libby" wrote in message ... The current formula works as is. I'm trying to modify the current formula so that I don't have to munually change all of the 19's to 20's tomorrow, then to 21's the next day, then to 22's, etc. -- Libby "Libby" wrote: Here is the formula =+'19'!$F$17 where '19' is referencing a tab name representing the day of the month. I have multiple formulas in the spreadsheet referencing the current day of the month sheet ie 19 in this case. How do I embed a cell reference into the formula so that I can just change one cell from 19 to 20 to 21,etc rather than going to each formula and changing it to a 20, 21, etc. -- Libby |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell reference
Another if you need 2 digit days:
=indirect("'" & text(a1,"dd") & "'!f17") or if you don't need 2 digit days: =indirect("'" & text(a1,"d") & "'!f17") In both cases, you don't need the $f$17. Since it's a string, it won't change if you copy that formula to another cell. Libby wrote: The current formula works as is. I'm trying to modify the current formula so that I don't have to munually change all of the 19's to 20's tomorrow, then to 21's the next day, then to 22's, etc. -- Libby "Libby" wrote: Here is the formula =+'19'!$F$17 where '19' is referencing a tab name representing the day of the month. I have multiple formulas in the spreadsheet referencing the current day of the month sheet ie 19 in this case. How do I embed a cell reference into the formula so that I can just change one cell from 19 to 20 to 21,etc rather than going to each formula and changing it to a 20, 21, etc. -- Libby -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Changing sheet reference to cell reference | Excel Worksheet Functions | |||
absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |