| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Deleting by sorting dates
If column A is populated by dates with 24 other columns holding data, How can
I delete data after 1 year old by using column A? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Auto Deleting by sorting dates
Maybe you could apply data|filter|autofilter and show only those dates that are
at least a year old. Then delete those visible rows. drc wrote: If column A is populated by dates with 24 other columns holding data, How can I delete data after 1 year old by using column A? Thanks -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting/Sorting | Excel Worksheet Functions | |||
| Sorting and Deleting Help | Excel Worksheet Functions | |||
| Deleting data by sorting dates | Excel Discussion (Misc queries) | |||
| sorting and deleting sheets | Excel Programming | |||
| Sorting and deleting empty cells | Excel Discussion (Misc queries) | |||
Linear Mode
