print selected rows
 

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.

print selected rows
 

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.

--
Regards,

OssieMac


"Date Less" wrote:

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.

print selected rows
 

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

"Date Less" wrote:

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.