Drop Down lists?
I am trying to create a drop down list in a cell when the item is selected it
will populate values for that item in different cells. i.e In a drop down menu you can select different types of shirts. When you select a particular shirt from that drop down menu it will populate a price in a different cell and a color in another cell. These values will be constant for each item. Thanks in advance... |
Drop Down lists?
YOu can use data validation to create the dropdown list, and VLookup
formulas to show the related information in other cells. There are instructions here for an order form, that uses those techniques: http://www.contextures.com/xlOrderForm01.html Juhnny wrote: I am trying to create a drop down list in a cell when the item is selected it will populate values for that item in different cells. i.e In a drop down menu you can select different types of shirts. When you select a particular shirt from that drop down menu it will populate a price in a different cell and a color in another cell. These values will be constant for each item. Thanks in advance... -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 09:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com