Forum Discussion
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...
See the attached demo. It uses named ranges and an INDIRECT formula.
- 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.That would require VBA code. Would that be OK?
And do you also want to shift cells down when you select "Yes"?
Based on the doc you sent over with the macro, how would I directly apply this to my sheet?
