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.
Bookmarks