ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro for hiding all rows accept those selected by a dated column? (https://www.excelbanter.com/excel-programming/442916-macro-hiding-all-rows-accept-those-selected-dated-column.html)

Doug

Macro for hiding all rows accept those selected by a dated column?
 
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?
--
Thank you!


All times are GMT +1. The time now is 03:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com