Thread: cell reference
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Libby Libby is offline
external usenet poster
 
Posts: 151
Default 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