Print data based upon date entry

[Bruise]

Hello group!

I'm trying to develop a code assigned to a button so when the button is
pressed, the code opens a form, asks for a specific date to search for, and
returns with a printable result listing column A (Date) and the
corresponding columns B, C, D and E.

I'm totally lost at where to even start. Any help would truly be
appreciated.

Mark

 

[Guest]

A simple solution could be to Create your button, assing a sub to it, in the
sub you use the input box command and the result gets stored in a variable,
the variable then is used in combination with a filter placed in column "A"
where the date should be, then select all visible cells, and copy them to a
different sheet. At the end of your first sub, you set a few instructions to
find the area in use and set it as the printing area, once this is printed
you clear the whole sheet to prepare it for the next set of data to be
printed.

Michael Arch.