I have an excel workbook that will be uploaded to a company-wide intranet and downloaded by various users. Because of this, I need to make the workbook very user-friendly so a macro would not be an appropriate solution.
I have a worksheet, "Abbreviated Risk Register," which is pulling select data from the main worksheet, "Risk Register." The data is being pulled by the basic formula of ='Project Risk Register'!A1. Each company user may enter as much data on the main worksheet as they like, so I've entered about 150 rows of formulas on the "Abbreviated Risk Register" worksheet. If a user fills in 20 of the 150 rows on the "Abbreviated Risk Register" and hits print, all 150 rows still print out. How do I format the sheet so that the blank cells (formula is there, but the value is zero) so that only those rows with text (non-blanks) print out?
Bookmarks