I know this kind of defeats the purpose, but is it possible to have an Excel 2007 spreadsheet with a cell that has:
- Validate against a list that is column in the spreadsheet.
- If not in that list, allow a user to enter a "custom" item that was not anticipated by the author that is not included in the list in #1, so essentially skip validation in this case.
I assume there might be a way to pull this off, and I would prefer without VBA since this question stems from a user who wants a lot with a little programming experience.