View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kevin M
 
Posts: n/a
Default 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