I am relatively new to trying to create formulas. And use excel help, but cant find an answer to this question.... alsoI have no idea how to post a copy of what I am doing in here like many other users have. I apologise...
So here is my question(s);
I use an excel spreadsheet as a template for invoicing.
I have created lists and use drop down menus to select the customer name and accounts etc. easy as! If I have a customer who doesn't appear in the drop down list but I want to add them, without adding them to my permanent list is it possible?
For example, I have used "other" in the drop down list..... but this doesn't let me add an actual name cause it creates an error saying it isn't an allowed value. (ie doesn't appear in the list)
What I'd like to be able to do was select other from the drop down list and then when other is selected, it could prompt me to enter a free text name?
Hope that I am clear enough to make sense and look forward to your help! Thanks in advance! Mick