Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dependent dropdown boxes
Hi all, TIA..
I've made dependent boxes before but this one is a little trickier. I have a list of about 3500 entries that i'd like to utilize on a seperate sheet as a requisition form. To help the user I'd like them to be able to choose a number assigned to each group then in the second dropdown (now filtered from the first) choose a part number from that group and finally i have a VLOOKUP searching the part number to give its' description. The list is set up like this: Group Part # Description 1 100210 lined paper 1 100231 stapes 2 100456 blank cd's 2 2 2 3 3 3 3 3 and so on. the groups range from 2 to 47 Hope this is clear enough and again, thanks. Kevin M |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dropdown boxes (box 1 result = box 2 | Excel Worksheet Functions | |||
Dependent List (via Data Validation) Error | Excel Worksheet Functions | |||
check boxes - copy | Excel Discussion (Misc queries) | |||
dependent drop down boxes and dynamic ranges | Excel Worksheet Functions | |||
dependent dropdown | Excel Discussion (Misc queries) |