Results 1 to 3 of 3

Hide / Unhide Row on a Sheet based on the Value of a Cell on Another Sheet

Threaded View

  1. #1
    Registered User
    Join Date
    05-13-2013
    Location
    Sacramento, CA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Hide / Unhide Row on a Sheet based on the Value of a Cell on Another Sheet

    I am looking to create an input sheet that will transform to an invoice and where there is no value on certain line items, those rows on the invoice should be hidden.

    Example

    Ref Sheet

    Item A (Cell B12) = 0
    Item B (Cell B13) = 0
    Item C (Cell B14) = 1

    Invoice Sheet

    Row 12 - Hidden
    Row 13 - Hidden
    Row 14 - Show

    I have attempted to build the macro for the sheet so that it changes automatically as the information is inputted, but the row never hides. Any help is appreciated.
    Last edited by neslotna; 05-15-2013 at 12:27 PM.

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