+ Reply to Thread
Results 1 to 6 of 6

Display/hide rows based on dropdown list

  1. #1
    Registered User
    Join Date
    12-06-2021
    Location
    Winnipeg
    MS-Off Ver
    Office Plus 2016
    Posts
    3

    Display/hide rows based on dropdown list

    Good day folks, I have data in the worksheet as per the following:



    Introduction (Row 1 to 9)

    City of Toronto (Row 10-19)

    City of Winnipeg(Row20-29)

    City of Vancouver(Row 30-39)

    City of Montreal (Row 40-49)

    City of Calgary (Row 50-59)

    Ending statement (Row 60)



    There are various data pertaining to each city from column A to Colum J.



    There is a dropdown in D3 with city names as stated above. I would like to keep rows 10 to 60 hidden by default if no option is selected in cell D3.



    If I select "City of Toronto" then only rows 10-19 should appear, the rest can stay invisible. If I select option "City of Montreal" then only it should show only rows 40-49.



    Row 1 to 9 can stay visible all the time.



    Any help achieving this would be highly appreciated.



    Thank you so much in advance.
    Last edited by Najz420; 12-06-2021 at 08:58 PM. Reason: Upload attachment

  2. #2
    Forum Contributor
    Join Date
    12-08-2020
    Location
    South Korea
    MS-Off Ver
    Excel 2010
    Posts
    108

    Re: Display/hide rows based on dropdown list

    attached file please.
    Caring environment and nature. caring you.

  3. #3
    Registered User
    Join Date
    12-06-2021
    Location
    Winnipeg
    MS-Off Ver
    Office Plus 2016
    Posts
    3

    Re: Display/hide rows based on dropdown list

    Quote Originally Posted by chronjy View Post
    attached file please.
    Hi there, I am sorry I am new to this, tried uploading the file, not sure if you can see it now?

  4. #4
    Forum Contributor
    Join Date
    12-08-2020
    Location
    South Korea
    MS-Off Ver
    Excel 2010
    Posts
    108

    Re: Display/hide rows based on dropdown list

    Try this.
    Attachment 758384

  5. #5
    Registered User
    Join Date
    12-06-2021
    Location
    Winnipeg
    MS-Off Ver
    Office Plus 2016
    Posts
    3

    Re: Display/hide rows based on dropdown list

    The attachment link not working for me. I am getting the following error message.

    vBulletin Message
    Invalid Attachment specified. If you followed a valid link, please notify the administrator

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,546

    Re: Display/hide rows based on dropdown list

    To upload a file utilize the instructions in the banner at the top of the page.
    Note that the paperclip icon doesn't work.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Replies: 3
    Last Post: 06-23-2020, 11:30 AM
  2. Hide Rows based on the value in a dropdown cell
    By cajunlibra in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-08-2016, 11:00 AM
  3. Hide/Unhide rows based on Yes or No answers to questions by dropdown list.
    By Johny1 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-12-2015, 06:57 PM
  4. hide/unhide columns based on dropdown list.
    By bg781np in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-18-2013, 07:13 PM
  5. [SOLVED] VBA to hide cells based on dropdown list using If/Else/Then
    By JOHNROK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2012, 06:13 PM
  6. Hide Rows based on dropdown list in another sheet
    By Jeeperman4x4 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-04-2011, 08:01 PM
  7. Hide Rows based on dropdown selection...
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-27-2008, 04:09 PM

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