Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Validation from Database (not sorted)
Hi to everyone,
Does anyone know how to validate a List from a Database not sorted? the point is, In cell A1 I type a file number to get in B1 a dropdown list with the products related with that file. The list (validation) is coming from a Database which is not sorted since I have to update it each day (lets say I have the database in columns D and E {D(File Number) and E(Product number)} Anyone knows how to get the list from the database? Thanks in advance bc this is driving me really crazy!!! Regards, Faico |
#2
|
|||
|
|||
How about, instead of typing the file number in A1, you have a drop-down
list to choose from? Then, that choice determines a second drop down list in B1. Debra Dalgleish has a number of web pages dedicated to that subject of drop downs and "dependant lists" originating within Data Validation. Check out this link: http://www.contextures.com/tiptech.html And scroll down to the D's, and go through the pages on Data Validation. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "faico" wrote in message ups.com... Hi to everyone, Does anyone know how to validate a List from a Database not sorted? the point is, In cell A1 I type a file number to get in B1 a dropdown list with the products related with that file. The list (validation) is coming from a Database which is not sorted since I have to update it each day (lets say I have the database in columns D and E {D(File Number) and E(Product number)} Anyone knows how to get the list from the database? Thanks in advance bc this is driving me really crazy!!! Regards, Faico |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links to External Database | Excel Discussion (Misc queries) | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Duplicates in database validation | Excel Discussion (Misc queries) | |||
Data Validation Window? | Excel Discussion (Misc queries) |