Hi - hoping someone can help.
I have a drop down list (of text) within my spreadsheet. I would like the list to be able to accept manual unique entries, ie those not part of the list, as well as those that are part of the list.
When I try and do this there is an error message - 'the value you entered is not from the required list'.
Is there a way I can manually override this and input a unique text string?
many thanks
Bookmarks