I'm trying to figure out how to dynamically print a report based on whether cells have text or not.

I have an Excel 2010 Userform for collecting information about subcontractor performance on a weekly basis. I've setup the userform to record data for up to five work related performance issues, although there are rarely more than two or three issues per week. Each issue must have (1) one of three issue types (Delivery, Performance, or Exceptional Performance), (2) one of two categories (Satisfactory or Unsatisfactory), and (3) a Contract Requirement. So there are a potential of approximately 54 cells of data that could be printed into a formatted report.

My issue is that I only want to print cells with data AND format the output so that it only presents the issues documented for each week. Otherwise, I have to format the output to display every cell whether or not it has data.

Can this be done?

Thanks!
Mark in Austin