Results 1 to 5 of 5

Automatically Hiding rows based on checkboxes

Threaded View

  1. #1
    Registered User
    Join Date
    09-19-2012
    Location
    Philadelphia, US
    MS-Off Ver
    Excel 2010
    Posts
    9

    Automatically Hiding rows based on checkboxes

    Hi all!

    I'm trying to figure out a way to automatically hide a number of rows based on a checkbox. Basically I want to hide rows 27:37 if a checkbox is NOT checked, and show the same rows if the checkbox is checked. I currently have the rows grouped, however I need to really tighten this workbook up and the grouping doesn't allow the clean look that I'm hoping to achieve.

    Attached is a sample of what I am trying to accomplish. I would like to be able to hide rows 27:37 if the checkbox for "Land Tracts" IS NOT checked, as well as show rows 27:37 if the checkbox IS selected.

    I really appreciate any help the community could offer.

    Jake
    Attached Files Attached Files
    Last edited by Jake Bierly; 09-19-2012 at 06:07 PM. Reason: Solved

Thread Information

Users Browsing this Thread

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

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