Hi,
Please can someone help me?
I am trying to put together a monthly check sheet for work.
It's a big ask but what I would like is a code that once the monthly check is completed it then hides that column until we get the the following month and then it does it again and so on.
There will only be 1 cell within each range with a value and the value will be a number but could be any number within reason.
The ranges are:
Jan = G7:G68.
Feb = G69:G124
Mar = G125:G186
Apr = G187:G246
May = G247:G308
June = G309:G368
July = G369:G430
Aug = G431:G492
Sept = G493:G552
Oct = G553:G614
Nov = G615:G674
Dec = G675:G736
Any help would be appreciated.
Thanks
Dan
Please can someone help me?
I am trying to put together a monthly check sheet for work.
It's a big ask but what I would like is a code that once the monthly check is completed it then hides that column until we get the the following month and then it does it again and so on.
There will only be 1 cell within each range with a value and the value will be a number but could be any number within reason.
The ranges are:
Jan = G7:G68.
Feb = G69:G124
Mar = G125:G186
Apr = G187:G246
May = G247:G308
June = G309:G368
July = G369:G430
Aug = G431:G492
Sept = G493:G552
Oct = G553:G614
Nov = G615:G674
Dec = G675:G736
Any help would be appreciated.
Thanks
Dan