Print selection based on dates

nparsons75

Well-known Member
Joined
Sep 23, 2013
Messages
1,179
I have a system where items are recorded daily onto a spreadsheet via a userform. In column A are the dates. Each week (ish) the items that have been recorded are taken away. When they are taken I need to print the report for those items. So For all the items that have been reported within 2 dates I want to print a report.

example.

Pencils.

We have a number of pencils, lets say 100. Each day we use them, the more we use them the more blunt they become. When each one becomes blunt they are recorded into a spreadsheet via the excel user form and placed in the sharpening box. At the end of week one we have 14 pencils for example. These 14 pencils are to go away for sharpening. Each pencil has a unique identification number.

When the pencil sharpening person comes to collect the pencils I want him to press a button and print a report that contains those 14 pencils along with their data (ID number). It is important he only prints the data containing the 14 pencils and nothing prior to them (as they would have already been dealt with the previous week). Pretty much like printing an order form.

From this report the pencil sharpening person knows which pencils he has, and we also know by having a copy which ones have been taken. (would be even better if there was a way to highlight the cells a color once printed but very difficult I think).

The only way i can think of is if the person selects between two dates and then presses print. A report showing any pencil recorded between those dates would then be printed.

Only my thoughts, if anyone knows how I could do this that would be fantastic, or any better way of doing it even better.

Thank you all in advance. Fingers crossed.
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Watch MrExcel Video

Forum statistics

Threads
1,130,106
Messages
5,640,134
Members
417,126
Latest member
Jeffman52

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