View Single Post
 
Old 05-17-2018, 10:51 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

This example worksheet was created for another purpose, cascaded validation lists were a byproduct. You can ignore all except:
1. On sheet Persons columns PersonName and PersonOrganization. This matches with your Continent-Country list.
2. On sheet Organizations column OrgName. You have to replace this with list of continents. As this list hardly changes ever, you can later hide the sheet with continents list, or you can enter the list of continents directly as data validation list source, and drop the Continents sheet at all. But this may mean more work when designing the application.
3. Sheet Hidden is essential, as here the list of persons (countries) belonging to selected organization (continent) is generated. as the name suggests, this sheet is meant to be hidden from users. NB! This example was created to select organization and person in 2 cells! For cascading data validation lists used in tables, slightly different approach is needed - on this hidden sheet is calculated a table with a column for every continent, and into every column a list of countries from this continent. And for table where you want to select country for selected continent, you have to define a dynamic named range which returns the list of countries for selected continent from proper column of this Hidden sheet. In your opening post you did write "two input field" - when you really want two table columns, then let me know.

Quote:
I would love to filter the data based on 1 table (2 columns, continuing rows) but not sorted...
You'll have a sheet with list of countries by continent and your main sheet where you select continent and country visible. You can't have those 2 in one and have any working formulas!. And as minimum you'll have one hidden sheet, which must not bother you at all.
Reply With Quote