Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 05-17-2018, 10:51 PM
ArviLaanemets ArviLaanemets is offline dynamic dependent drop down list based on input with reference to a two column table Windows 8 dynamic dependent drop down list based on input with reference to a two column table Office 2016
Expert
 
Join Date: May 2017
Posts: 949
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Increase number in cell, based on value in adjacent cell scottyb Excel 3 02-02-2017 03:51 AM
Help with Vlookup in a Dependent drop down list angelmr Excel 0 11-29-2016 09:25 AM
Get all rows based on input values from a list soolsen Excel 1 03-27-2016 08:11 PM
How to "hard link" two adjacent cells to a data validation drop down list? Geza59 Excel 10 10-19-2012 11:56 AM
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell Frogggg Excel 1 10-25-2011 08:44 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft