View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Docktondad Docktondad is offline
external usenet poster
 
Posts: 2
Default Referencing Cell Next To Today's Date Cell

Thanks to all for the suggestions. PCLIVE had the answer I was looking for.
He read my mind perfectly.

Docktondad

"Docktondad" wrote:

Please bear with the question: Using Excel 2002 w/SP/3 and Windows XP w/SP2.
I have two columns: 1) A2...A137 are daily dates. 2) B2...B137 are cells
that are filled in (one cell) each day and contain my weight. In Cell J37 I
want to have the data in the cell to the right of the current day displayed
automatically as each day changes. How do I reference the data in Column B
to do this? Thanks,

Docktondad