+ Reply to Thread
Results 1 to 1 of 1

Hiding rows based on drop down selection of cell

  1. #1
    Registered User
    Join Date
    06-25-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    15

    Question Hiding rows based on drop down selection of cell

    First time poster here so I hope I do this correctly!

    Using Excel 2010

    I am creating a form that will display different rows if certain selections are made. For example; cells B70-B72 are a drop down list with two options, '-' or 'sqrt'. If none equal the 'sqrt' symbol then I want to hide row 56. If one does, then row 56 will be displayed.

    If this is required, the drop-down list is selecting from Sheet:'List' where D7 is 'sqrt' and D8 is '-'

    There will be quite a few of these dependencies so ideally, I would be able to have many instances of the code and I could simply edit which cells are the drop down, and which cells would be shown or hidden. So for example, I could run the same code but change the drop down list to be cell B27 and then rows 36,67, and 45 would be hidden or shown.


    Any help at all would be fantastic.
    Thanks!
    Attached Files Attached Files
    Last edited by J-Fly; 06-25-2012 at 02:32 PM. Reason: Added Dummy Workbook

+ Reply to Thread

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