Creating a Dropdown that is Related to the Value Given in Another Cell

G

Groovingirl13

I am looking to create a drop down menu

So image in this... in cell C will be drop down menu that is related t
the the value of what the drop down menu in cell A is. It may be a
appliance such as a Dishwasher or whatever the particular applianc
might be that is being inspected in an home. Then, when the applianc
is selected in the cell A drop down, the options in the Drop down Men
in cell C will have the corresponding options that are relate
specifically to that particular appliance

So basically if cell A = Dishwasher then the drop down menu in cell
should reference all the options that are Dishwasher relate

And if Cell A = Water Heater then the drop Down Menu in cell C shoul
reference all the options that are Water Heater Relate

And….so on&#8230

I have searched for a solution and nothing matches my scenari
perfectly. Help
 
M

Mazzaropi

Groovingirl13;1611581 said:
I am looking to create a drop down menu.

So image in this... in cell C will be drop down menu that is related t
the the value of what the drop down menu in cell A is. It may be a
appliance such as a Dishwasher or whatever the particular applianc
might be that is being inspected in an home. Then, when the applianc
is selected in the cell A drop down, the options in the Drop down Men
in cell C will have the corresponding options that are relate
specifically to that particular appliance.
So basically if cell A = Dishwasher then the drop down menu in cell
should reference all the options that are Dishwasher related
And if Cell A = Water Heater then the drop Down Menu in cell C shoul
reference all the options that are Water Heater Related
And….so on…
I have searched for a solution and nothing matches my scenari
perfectly. Help!
Click to expand...

Hi Groovingirl13.

Take a look at these old posts where I solved a question like yours.

http://www.excelbanter.com/showpost.php?p=962936&postcount=2

http://www.excelbanter.com/showpost.php?p=1601163&postcount=5

Tell if it worked for you.

Have a Nice day
 
G

Gord Dibben

Garry

You're too low-key<g>

I would use "excellent" when describing Debra's site.

Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Link a text box based on drop down box with four options MS Word 365 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Creating drop downs in a cell contingent on another drop down 1
Multi layered drop down 1
How do I designate dates using info from a cooresponding drop down list? 3
Word VBA - Automatic change content of a cell in table using dropdown list 5
Assign numerical value to cell based on selection from drop-down m 1

Top