Is there a way to have a macro look in an excel database that is sorted by
date and find all the records that have a date that is within the current
month, then select only those rows and certain columns, e.g., columns D
through K and set the print area using that range? The number of records
will be different each month, but they will always be contigous.