I have a checklist I want to fill the dates - Monday to sunday and also fill the week ending date too.
I then want to print the sheet for the entire month.
For example, 01/08/2022 -07/08/2022 in the "Mon to Sun" boxes (C3-I3) and then 07/08/2022 in K1. And then have this repeat for each week until it reaches the end of the month - 08/08/2022-14/08/2022 etc etc.
Is this possible with VBA code?
I then want to print the sheet for the entire month.
For example, 01/08/2022 -07/08/2022 in the "Mon to Sun" boxes (C3-I3) and then 07/08/2022 in K1. And then have this repeat for each week until it reaches the end of the month - 08/08/2022-14/08/2022 etc etc.
Is this possible with VBA code?
| Loss Prevention Checklist.xlsm | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | |||
| 1 | Checklist | week ending Sunday : | ||||||||||||||
| 2 | Day / Date: | Mon | Tues | Wed | Thurs | Fri | Sat | Sun | COMMENTS : | |||||||
| 3 | ||||||||||||||||
Sheet1 | ||||||||||||||||
