| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation Lists - Generating a list based on another list'sresult
I have been searching the web all day, and I am not sure how to
approach this problem. Here is a basic worksheet: ID Name Serial # 1 Joe ck9033n2389d 2 Joe 349-283fjrjh55 3 Bob c90320j34n5kjdf 4 Joe kgho95injhs 5 Bob 2353gdf745 Step 1: I have a drop down list with only one instance of each of the "Name" variable. Step 2: Upon selecting that name, I would like another drop down box with all the serial numbers associated with that person. Step 3: Then, based on the serial number, display stats in the same row for that item. Step 2 is what I am having problems with. Any direction would be extremely helpful. VB? Access? A formula I can't think of? I would be greatful for any help you could provide. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation & Dependent Lists -from same list? | Excel Worksheet Functions | |||
| data validation, totaling values based off dropdown lists | Excel Discussion (Misc queries) | |||
| Generating a new list based on cell criteria | Excel Worksheet Functions | |||
| How to clear validation lists based on other validation lists | Excel Discussion (Misc queries) | |||
| Data Validation lists - entering value not in list | Excel Discussion (Misc queries) | |||
Threaded Mode
