Forum Discussion
EVIED1999
Aug 22, 2022Copper Contributor
Drop down lists
Hi guys, First time posting - relative newbie! I just wanted to ask how to solve the following: I would like to have a yes or no drop-down so if someone selects yes the following rows sho...
HansVogelaar
Aug 22, 2022MVP
See the attached demo. It uses named ranges and an INDIRECT formula.
EVIED1999
Aug 23, 2022Copper Contributor
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.
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.
- HansVogelaarAug 23, 2022MVP
That would require VBA code. Would that be OK?
And do you also want to shift cells down when you select "Yes"?
- EVIED1999Aug 23, 2022Copper Contributor
Based on the doc you sent over with the macro, how would I directly apply this to my sheet?
- HansVogelaarAug 23, 2022MVP
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.
- EVIED1999Aug 23, 2022Copper ContributorThe 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!
- HansVogelaarAug 23, 2022MVP
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.