Drop down lists

Question

Hi guys,&nbsp;First time posting - relative newbie!&nbsp;I just wanted to ask how to solve the following:&nbsp;I would like to have a yes or no drop-down so if someone selects yes the following rows should populate with something like, "item 1", "item 2" and so on. Should the person select no from the drop down, the row below only populates once with "item".&nbsp;&nbsp;How would I go about doing this?&nbsp;Ty~

hansvogelaar · Answer

EVIED1999&nbsp;
See the attached demo. It uses named ranges and an INDIRECT formula.

evied1999 · Answer

Absolutely fantastic!! Thank you 🙂Is there a way to then shift cells up if someone toggles "no"? As it stands it leaves blank rows after Item. Sorry if I'm asking too much.

hansvogelaar · Answer

EVIED1999&nbsp;
That would require VBA code. Would that be OK?
And do you also want to shift cells down when you select "Yes"?

evied1999 · Answer

The way it is currently, when someone replies with the Yes, it populates the next few rows using the method you sent me previously, but when someone replies with no it still leaves the next few rows blank. So it would just be to remove the blank cells 🙂 anything would help!

hansvogelaar · Answer

EVIED1999&nbsp;
We do have to shift down on Yes, otherwise you'd get a #Spill! error since there is no room for the longer list.
See the attached version. You'll have to allow macros.

Forum Discussion

Drop down lists

Share

Resources