I have a report in which i use a summary sheet to fill in the data and then it populates sheets with data using vba, vlookups, etc. I have a report number in cell j4. I want a way to print each of the sheets that get populated if and only if they do not contain n/a. I have it set up so it puts n/a in from a vlookup table if there is no report number listed. I.E. It defaults to n/a. Is there a way to do this so I don't have to waste paper and pull out all the n/a report pages when I print?

Also, I think the print area is the same for each sheet, but as a side note is there a way to set the print area globally, so when I add a new sheet or change somthing I don't have to change and set the print area each time? This would be an issue in trying to print like I would like to.

Should this be moved to a vba script question?

Thanks, in advanced,
David