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
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,111
Messages
5,857,448
Members
431,880
Latest member
kar2rost

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top