+ Reply to Thread
Results 1 to 6 of 6

hiding/unhiding rows based on a selection from a drop down

  1. #1
    Registered User
    Join Date
    07-21-2014
    Location
    Cincinnati, OH
    MS-Off Ver
    2010
    Posts
    3

    hiding/unhiding rows based on a selection from a drop down

    Hi,

    I'm trying to formulate a spreadsheet that will hide/unhide rows depending on a selection made in a drop down (list). There are 3 options in the drop down that correlate to a type of request; whichever option is selected needs to only show the relevent rows for that type. I've listed a reference in column A for each row that would need to show for the specific type of request. I'm not very good with macros but I think there might be a way to accomplish this. I've attached the document; any help would be appriciated.

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: hiding/unhiding rows based on a selection from a drop down

    Hiding an unhiding rows by the B1 drop down would require a surgical list of what should happen for each choice.

    1) NEW ACCOUNT REQUEST
    - all rows unhidden
    - row 9 hidden
    2) NEW LEVEL ADD
    - all rows unhidden
    - rows 4:21 hidden.

    Etc... you get the idea. Can you provide?
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    07-21-2014
    Location
    Cincinnati, OH
    MS-Off Ver
    2010
    Posts
    3

    Re: hiding/unhiding rows based on a selection from a drop down

    Yes, that would be helpful wouldn't it...

    1. New Account Request
    - all rows unhidden
    - row 9 hidden
    2. New Level Add
    - all rows unhidden
    - rows to hide:
    - 5:8
    - 12:13
    - 18
    - 20:33
    - 68:76
    - 83
    - 85
    - 88
    - 91
    - 94
    - 96:97
    3. New User Add
    - all rows unhidden
    - rows to hide:
    - 5:8
    - 10:49
    - 68:76
    - 83:99

    Hope this helps.

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: hiding/unhiding rows based on a selection from a drop down

    1) Delete the Module1 that you added, the code we are creating does not go there.
    2) Double click the Sheet1(all) in the VBAProject on the left to open the "all" sheet module
    3) Paste in this event code into that module... this macro will run itself each time B1 is edited.
    Please Login or Register  to view this content.
    Example: http://screencast.com/t/cvEiAr1MmO8t

  5. #5
    Registered User
    Join Date
    07-21-2014
    Location
    Cincinnati, OH
    MS-Off Ver
    2010
    Posts
    3

    Re: hiding/unhiding rows based on a selection from a drop down

    Thank you so much! That worked perfectly. I appricate the help!

  6. #6
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: hiding/unhiding rows based on a selection from a drop down

    As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
    FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hiding and unhiding rows based on a CountA value
    By juliettelam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-15-2014, 12:23 PM
  2. Help hiding rows based on drop down selection
    By J-Fly in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 11-23-2012, 02:07 PM
  3. [SOLVED] Hiding/Unhiding Rows Based on Dropdown Box
    By SubParLlama in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-14-2012, 12:29 PM
  4. Hiding rows based on drop down selection of cell
    By J-Fly in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2012, 01:37 PM
  5. Hiding Rows based on Drop Down menu selection
    By smurph_27 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2008, 08:36 PM

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