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


[TABLE="width: 778"]
<tbody>[TR]
[TD]Customer Name
[/TD]
[TD]Item required
[/TD]
[TD] Mon
[/TD]
[TD]Tue
[/TD]
[TD]Wed
[/TD]
[TD]Thu
[/TD]
[TD]Fri
[/TD]
[TD]Sat
[/TD]
[TD]Sun
[/TD]
[TD]Date required (from)
[/TD]
[TD]Date required (to)
[/TD]
[/TR]
</tbody>[/TABLE]

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