Hi, I would appreciate any help creating a macro to hide columns for a range of cells based on todays date minus 3 years. I currently have about 20 columns. Each column heading is a persons name. Each column under the persons name has 10 rows of dates. To send out a monthly report of people that have dates coming due (Todays date minus 3 years), I would like to hide all of the other columns that don't meet the criteria. For instance, I may have 20 columns and only 1 column contains a date outside the date range that would need to be reported. In that case the other 19 columns would be hidden. any help would be greatly appreciated. Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Hiding columns based on date range
- Thread starter natecrone
- Start date
Similar threads
- Question
- Solved
