Hello,

I have the current formula for a data validation list. This list is used to print an invoice. The macro rolls through every tenant in the validation list and prints an invoice. Some of these tenants however do not require an invoice to be printed based off of criteria in column E. For example if column E for a tenant is labeled Gross, Fixed, Specialty or Vacant and invoice should not be printed. Any suggestions?

Like I mentioned this formula works for the validation list. It is just printing unneeded invoices wasting paper and causing people to have to sort through the printouts and trash the unneeded ones.

=OFFSET('Tenant Tax Recovery Summary'!$J$8,0,0,COUNTA('Tenant Tax Recovery Summary'!$J:$J)-2,1)