tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
Ok so I have a list of dates in column AH16 to CH16 that show every monday of this year in reverse order
(CH16 = 03/01/2022 go to the left with each cell going up 7 days until AH16 = 02/01/23)
What i would like is a macro that can do this,
when i select the page, Find this weeks date (that will be the Monday for the week we are in i.e. 07/02/2022 and hide the columns between AH and that column,
Please help if you can
Thanks
Tony
Ok so I have a list of dates in column AH16 to CH16 that show every monday of this year in reverse order
(CH16 = 03/01/2022 go to the left with each cell going up 7 days until AH16 = 02/01/23)
What i would like is a macro that can do this,
when i select the page, Find this weeks date (that will be the Monday for the week we are in i.e. 07/02/2022 and hide the columns between AH and that column,
Please help if you can
Thanks
Tony