print selected rows

[Date Less]

I have 9 columns in a large database once a week I would like to print the
rows that have a date within that week in column 4. Column 4 has dates when a
job has been performed and I don't need to print last weeks data.

 

[OssieMac]

Try using Autofilter. Lookup in Help for more info. You can then set the
filter to just include the dates you want and only those rows will be
displayed.

Depending on the version of xl that you have, you might need to use Custom
when actually setting the filter and make it Greater than or equal to and
less than or equal to.

 

[FSt1]

hi,
another way to consider...
high light the area you wish to print then run this macro to reset the print
area.
Sub Printtest()
ActiveSheet.PageSetup.PrintArea = ""
ActiveSheet.PageSetup.PrintArea = Selection.Address
End Sub

if you use it frequently enought, you could attach it to a custom icon.
i did.
Regards
FSt1