Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
Can I move down 12 rows in excel for every new entry | New Users to Excel | |||
How do I create an entry sheet that feeds info to other databases | Excel Discussion (Misc queries) | |||
Hitting Enter to Move Cursor to the Next Entry Cell | Excel Worksheet Functions | |||
Move the last entry in a column to a different cell, when the loc. | Excel Worksheet Functions |