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
|