| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to filter on today's date
I'ld like to automate a custom filter I use frequently
every day. It first filters on a couple of criteria which are no problem, but then I need to filter on whatever today's date is (less than or equal to). I've tried a couple of ways, including getting it to copy from a cell containing =today() and pasting the value in, but that doesn't work - it just leaves it blank, which is worse than useless. I suspect a bit of VBA will solve this, but I'm not too hot on that. Anyone any bright ideas? TIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
| How do I filter by today's date(changing) and before in a macro? | Excel Worksheet Functions | |||
| date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
| Reading File Name in VB Macro that contains today's date | Excel Discussion (Misc queries) | |||
| Macro to jump to today's date | Excel Discussion (Misc queries) | |||
Threaded Mode
