| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to autofilter current month
I have a column(AN) that has the month name in it..(JAN,FEB, etc.) and a
column with total admits(AI) in it. How would I create a macro that would autofilter by -does not equal 0(AI), and the current month(AN)? I could record the macro, but wasn't sure how to edit it to filter for the 'current' month. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to autofilter current month
This is just a formula for the current month, hope it helps.
=MONTH(NOW()) -------- Cheers, Anony "Tasha" wrote: I have a column(AN) that has the month name in it..(JAN,FEB, etc.) and a column with total admits(AI) in it. How would I create a macro that would autofilter by -does not equal 0(AI), and the current month(AN)? I could record the macro, but wasn't sure how to edit it to filter for the 'current' month. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retrieve data for previous 3, 6, 12 month given current month | Excel Worksheet Functions | |||
| Selecting the current month using a macro on a pivot table | Excel Discussion (Misc queries) | |||
| copy worksheet from previous month and rename to current month | Excel Programming | |||
| Delete current month using AUTOFILTER | Excel Programming | |||
| Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
Linear Mode
