Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Is it possible for the contents of cells in A1-B1-C1 and D1 to automatically clear (without deleting the row) when the date in A1 is more than 60 days old? - and - have the contents in the next cells down, move up to the top. In other words, this is a Pass Log and entries over 60 days old are no longer needed. A1, B1, C1 and D1 in the following ,will no longer be an issue in October so those cells would clear in October and the entries currently in A2, B2, C3 and D2 would move up one row and remain there till they were 60 days old..... and so forth down the sheet. A B C D 1 8/31/06 5776 Jones Smith 2 9/22/06 5778 Brown Wallace Thanks Johnnie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatic and manual calculations | Excel Discussion (Misc queries) | |||
Automatic and manual calculations | Excel Discussion (Misc queries) | |||
enable automatic refresh | Excel Worksheet Functions | |||
Please help with adding automatic data. | Excel Discussion (Misc queries) | |||
options to update automatic links | Excel Worksheet Functions |