VBA - Print sheets based on Date

dnorm

Board Regular
Joined
Dec 28, 2017
Messages
79
Hi All

I currently have 3 sheets that I am required to print every Monday (but forget). I want to add a VBA to automatically print a sheet when the data rows which fall on a Monday are filled in.
The print out comes from sheet/tab "KPI's" and the data which is compiled is under tab "Daily Data Input". The date is located in column B and the data is filled in from columns C:X.

Any help or pointers would be great cheers.
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Watch MrExcel Video

Forum statistics

Threads
1,099,029
Messages
5,466,116
Members
406,468
Latest member
Toto Li

This Week's Hot Topics

Top