Macro for hiding all rows accept those selected by a dated column?

D

Doug

Column A has dates in Descending order. I am wanting to hide all but a
predefined date range. So if there are dates in rows 5 through 300 and I want
to see only a week from today, it will show 5 weekdays starting with row 5. I
would like to do this also for 1 month, 3 months, 6 months, & 1 year. Can you
help me construct a macro please?
 

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

Similar Threads

Run macro on all files in a specific folder 3
Macro to hide rows 4
Macro for hiding/unhiding a set of rows 3
5 months prior to date macro help please 13
Macro for Hiding one column at a time in a range 2
VLookup or Macro? 0
Hiding rows based on a date function 4
hiding row if the cell is found in a differeent column 0

Top