Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello Mr. Peterson,
Is there a way to do the autofilter without having to literally choose the date each time? I mean, is there a way to set the autofilter to today's date all the time because if I get this working, my co-worker will be using it as well on my day's off, and she doesn't understand filtering or anything about excel. Is there a way to automate it all the time to show today's date? From, Nakia Allen "Dave Peterson" wrote: I'd apply data|filter|autofilter Filter to show the rows that need to be deleted and then delete those visible rows. Acute Mind wrote: I am writing a macro to hasten a report I have to do everyday at work. The final step is figuring out how to have Excel automatically delete all rows containing today's date or the largest date in a particular column. -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
How to use Today's date in a cell and make it stay the same date | Excel Discussion (Misc queries) | |||
Automate deletion process | Excel Worksheet Functions | |||
Count number of cells with date <today's date | New Users to Excel |