Printing specified row column combination based on value selected in cells

MichPr

New Member
Joined
May 6, 2014
Messages
10
Good morning.

I am hoping someone may be able to help please.

I have an excel spread sheet with the following headings


Customer Name
Item required
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Date required (from)
Date required (to)

<tbody>
</tbody>

Customer name
Item required
Time
Monday - this can be set to y or n for yes or no
Tue
Wed
Thursday
Fri
Sat
Sun
Date item required to

For each day of the week the user selects Y or N from a drop down data validation list
I wish to write some code , or use a command button or similar to check that if the entry for the day field = Y AND the date item required to field is greater than or equal to today’s date then the Customer Name, Item required and time is printed (where Y has been selected for mon, tue, wed... etc. Only)

Also, I need to print these reports daily, Monday’s data on a Monday, Tuesday’s report where Y has been selected each Tuesday etc.

I hope the above makes sense. I am a novice when it comes to these things.

Any help would be greatly appreciated. Thank you
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Watch MrExcel Video

Forum statistics

Threads
1,109,041
Messages
5,526,417
Members
409,701
Latest member
nitmani

This Week's Hot Topics

Top