View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CA_stateworker CA_stateworker is offline
external usenet poster
 
Posts: 3
Default How can I have Excel conditionally copy a cell

I would like to have excel copy/delete or cut from one cell to another based
on
Date. I have three columns with heading TODAY(), TODAY()-1, and TODAY()-2.
I would like to cut or copy the cell contents from TODAY() to TODAY()-1 when
the calendar date changes. Is it possible to do this without Visual Basic?

Thanks in advance for any help
--
stateworker