Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dependant Lists in Excel
Hello, I am trying to create a worksheet with many drop down lists that coincide with each other. I would like to have it where I have a machine drop down list, after selecting your machine, it will then select the proper list of attachments to match with the machine. With the attachment selection, I would need multiple lists to run from it. Example, the machine selected, and a list of attacments would show. From there I would like to select all 4 attachments, each attachment would be selected from a drop down list. Then from each the machine, and the attachments, I would like a price to show up in another column. Machine Wheel Loader $150,000 Attachments quick coupler $4000 fork rack $8000 bucket $12000 grapple $17000 Any ideas? Thx -- Browett ------------------------------------------------------------------------ Browett's Profile: http://www.excelforum.com/member.php...o&userid=36337 View this thread: http://www.excelforum.com/showthread...hreadid=561245 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dependant Lists in Excel
See if this helps:
http://contextures.com/xlDataVal02.html Biff "Browett" wrote in message ... Hello, I am trying to create a worksheet with many drop down lists that coincide with each other. I would like to have it where I have a machine drop down list, after selecting your machine, it will then select the proper list of attachments to match with the machine. With the attachment selection, I would need multiple lists to run from it. Example, the machine selected, and a list of attacments would show. From there I would like to select all 4 attachments, each attachment would be selected from a drop down list. Then from each the machine, and the attachments, I would like a price to show up in another column. Machine Wheel Loader $150,000 Attachments quick coupler $4000 fork rack $8000 bucket $12000 grapple $17000 Any ideas? Thx -- Browett ------------------------------------------------------------------------ Browett's Profile: http://www.excelforum.com/member.php...o&userid=36337 View this thread: http://www.excelforum.com/showthread...hreadid=561245 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I compare lists in Excel? | Excel Worksheet Functions | |||
lists from other lists in excel | Excel Worksheet Functions | |||
Changing case on mailing lists I receive in Excel 2003? | Excel Worksheet Functions | |||
How do I move excel address lists to outlook. and vice versa. | Excel Discussion (Misc queries) |