View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
3Nails 3Nails is offline
external usenet poster
 
Posts: 9
Default Save Today() in cell

I want to automatically save the current date in cell €śA1€ť. After saving the
sheet I will then copy the current sheet for tomorrows activity. I would
like the new current date to be automatically saved in the new sheet when
opened the next day. Basically have current date never change once it is
automatically updated in sheet. Any quick fix? Thanks€¦..