VBA to fill dates of current month sequentially

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!

Quick and dirty (so could be tidied up) but try this in your Workbook Open event:

Please Login or Register  to view this content.

BSB

Works a charm - thank you so much!!

No problem. Happy to help

BSB