Results 1 to 6 of 6

Display/hide rows based on dropdown list

Threaded View

  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

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