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'

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question