Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dropdown boxes (box 1 result = box 2 Greg Excel Worksheet Functions 4 August 14th 09 03:19 PM
Dependent List (via Data Validation) Error Dezdan Excel Worksheet Functions 2 December 2nd 05 12:33 AM
check boxes - copy MarkT Excel Discussion (Misc queries) 2 October 20th 05 04:33 PM
dependent drop down boxes and dynamic ranges philcud Excel Worksheet Functions 2 September 1st 05 01:03 PM
dependent dropdown Balder Excel Discussion (Misc queries) 2 April 21st 05 11:08 PM


All times are GMT +1. The time now is 10:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"