|
Creating a Dropdown that is Related to the Value Given in Another Cell
I am looking to create a drop down menu.
So image in this... in cell C will be drop down menu that is related to the the value of what the drop down menu in cell A is. It may be an appliance such as a Dishwasher or whatever the particular appliance might be that is being inspected in an home. Then, when the appliance is selected in the cell A drop down, the options in the Drop down Menu in cell C will have the corresponding options that are related specifically to that particular appliance. So basically if cell A = Dishwasher then the drop down menu in cell C should reference all the options that are Dishwasher related And if Cell A = Water Heater then the drop Down Menu in cell C should reference all the options that are Water Heater Related And….so on… I have searched for a solution and nothing matches my scenario perfectly. Help! |
Quote:
Take a look at these old posts where I solved a question like yours. http://www.excelbanter.com/showpost....36&postcount=2 http://www.excelbanter.com/showpost....63&postcount=5 Tell if it worked for you. Have a Nice day. |
Creating a Dropdown that is Related to the Value Given in Another Cell
Here's a good place to start...
http://www.contextures.com/xlDataVal02.html -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Creating a Dropdown that is Related to the Value Given in Another Cell
Garry
You're too low-key<g I would use "excellent" when describing Debra's site. Gord On Fri, 03 May 2013 20:38:20 -0400, GS wrote: Here's a good place to start... http://www.contextures.com/xlDataVal02.html |
Creating a Dropdown that is Related to the Value Given in Another Cell
On Sat, 4 May 2013 01:17:58 +0100, Mazzaropi
wrote: Groovingirl13;1611581 Wrote: I am looking to create a drop down menu. So image in this... in cell C will be drop down menu that is related to the the value of what the drop down menu in cell A is. It may be an appliance such as a Dishwasher or whatever the particular appliance might be that is being inspected in an home. Then, when the appliance is selected in the cell A drop down, the options in the Drop down Menu in cell C will have the corresponding options that are related specifically to that particular appliance. So basically if cell A = Dishwasher then the drop down menu in cell C should reference all the options that are Dishwasher related And if Cell A = Water Heater then the drop Down Menu in cell C should reference all the options that are Water Heater Related And….so on… I have searched for a solution and nothing matches my scenario perfectly. Help! Hi Groovingirl13. Take a look at these old posts where I solved a question like yours. http://www.excelbanter.com/showpost....36&postcount=2 http://www.excelbanter.com/showpost....63&postcount=5 Tell if it worked for you. Have a Nice day. Take a look at my tie sheet. It has increments for the minutes, and the user chooses the increment from a dropdown on the info page, and it changes the drop downs on the time sheet. |
Creating a Dropdown that is Related to the Value Given in Another Cell
On Fri, 03 May 2013 18:42:55 -0700, CellShocked
<cellshocked@thecellvalueattheendofthespreadsheet. org wrote: On Sat, 4 May 2013 01:17:58 +0100, Mazzaropi wrote: Groovingirl13;1611581 Wrote: I am looking to create a drop down menu. So image in this... in cell C will be drop down menu that is related to the the value of what the drop down menu in cell A is. It may be an appliance such as a Dishwasher or whatever the particular appliance might be that is being inspected in an home. Then, when the appliance is selected in the cell A drop down, the options in the Drop down Menu in cell C will have the corresponding options that are related specifically to that particular appliance. So basically if cell A = Dishwasher then the drop down menu in cell C should reference all the options that are Dishwasher related And if Cell A = Water Heater then the drop Down Menu in cell C should reference all the options that are Water Heater Related And….so on… I have searched for a solution and nothing matches my scenario perfectly. Help! Hi Groovingirl13. Take a look at these old posts where I solved a question like yours. http://www.excelbanter.com/showpost....36&postcount=2 http://www.excelbanter.com/showpost....63&postcount=5 Tell if it worked for you. Have a Nice day. Take a look at my tie sheet. It has increments for the minutes, and the user chooses the increment from a dropdown on the info page, and it changes the drop downs on the time sheet. Oooops! http://www.mediafire.com/view/?8atcc048a4dfndt |
Creating a Dropdown that is Related to the Value Given in Another Cell
Garry
You're too low-key<g I would use "excellent" when describing Debra's site. Gord On Fri, 03 May 2013 20:38:20 -0400, GS wrote: Here's a good place to start... http://www.contextures.com/xlDataVal02.html Yep! You're absolutely right, Gord. I'll get it right next time... -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
| All times are GMT +1. The time now is 10:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com