Aug 22 2022 09:51 AM
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 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".
How would I go about doing this?
Ty~
Aug 22 2022 10:42 AM
See the attached demo. It uses named ranges and an INDIRECT formula.
Aug 23 2022 03:25 AM
Aug 23 2022 03:49 AM
That would require VBA code. Would that be OK?
And do you also want to shift cells down when you select "Yes"?
Aug 23 2022 03:56 AM
Aug 23 2022 05:01 AM
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.
Aug 23 2022 05:39 AM
Based on the doc you sent over with the macro, how would I directly apply this to my sheet?
Aug 23 2022 06:09 AM
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.
Aug 23 2022 06:19 AM