Hi Everyone,
I'm trying to create a drop down list from a master list including only items I've selected via checkbox.
Attachment 395069
My first thought was to use the string =IF(B2=True,A2,"") in column C to create the list then ignore blanks in the data validation list settings. I've since worked out that this won't work, but I haven't been able to work out a simple way to do what I need.
Any help would be greatly appreciated.
Thanks all
Roo
Bookmarks