+ Reply to Thread
Results 1 to 3 of 3

Hide rows from selection in drop down menu

  1. #1
    Registered User
    Join Date
    09-26-2012
    Location
    Yapkank NY
    MS-Off Ver
    Excel 2010
    Posts
    1

    Hide rows from selection in drop down menu

    I am working with Excel 2010

    When a user selects RENEWAL QUOTE from the following choices in a drop down menu;
    QUOTE TYPE
    SALES QUOTE
    EVALUATION QUOTE
    RENEWAL QUOTE

    I heed to hide rows 16 to 31

    The drop down menu is in cell C2 which is a merged cell (C2, C3, D2, D3)

    Thanks for any help

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Hide rows from selection in drop down menu

    Hello TonyLB,

    Welcome to the Forum.

    From the attached WorkBook you will see how it is done!

    Also see the "Please consider" note at the bottom of this post.
    Attached Files Attached Files
    Last edited by Winon; 09-27-2012 at 01:33 AM. Reason: Corrected requirements
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Registered User
    Join Date
    09-26-2012
    Location
    Yapkank NY
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Hide rows from selection in drop down menu

    Thank you for the fix....I just needed to tweak the location fpr the data in my sheet and it worked!

    Thanks

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Hide rows from selection in drop down menu

    You are welcome!

    Thank you for the nice Rep.

+ 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