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 |
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 |
All times are GMT +1. The time now is 03:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com