View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Michael Michael is offline
external usenet poster
 
Posts: 791
Default Print data based upon date entry



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.
"Bruise" wrote:

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