+ Reply to Thread
Results 1 to 1 of 1

Excel 2007 : Only Print Rows Without Formula/Zero Value

  1. #1
    Registered User
    Join Date
    10-21-2005
    Posts
    18

    Only Print Rows Without Formula/Zero Value

    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?
    Last edited by Dahaynes; 05-18-2010 at 11:32 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1