Printing specified row column combination based on value selected in cells

[MichPr]

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