View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
belvy123 belvy123 is offline
external usenet poster
 
Posts: 71
Default Move cell info on new entry

Hi All

I am wanting to be able to enter dates into a cell in my sheet and each time
I enter a new date it will automatically move the last date down a row. I
want to have the most current 4 dates show. So there will be 4 rows of dates.

example

3/25/07
3/15/07
3/10/07
3/3/07

and now when I enter a new date it will look like this

3/30/07
3/25/07
3/15/07
3/10/07


Has anyone ever done this or know how to go about writiung a function or
formula to do this

Thanks for the help

DN
--
crunchin numbers