Hello!
I need some help with writing some vba code to auto populate a range of dates when the user opens my template.
On sheet 'CashTotals' I'd like column B to contain the dates of the current month, starting from B5.
On sheet 'PDQTotals' I'd like column B to contain the dates of the current month, starting from B7.
Then, I have sheets called '1,' '2,' '3,' etc. Each sheet is identical and I'd like the merged cell C2:J2on each sheet to contain the date of the current month that the sheet name refers to (i.e sheet '1' will have 01/03/19, sheet '2' 02/03/19 etc).
I have attached my workbook for some more insight!
Please could someone help me with this?
Thank you!
Bookmarks