1 Attachment(s)
Solved: prevent typing in a Data Val drop-down
Hello,
I have a workbook where client ID, name, address, etc is on one sheet (Cases) and the user can select the client's ID at the top of other sheets (via a drop-down with data validation for a named range) to populate the other sheets.
This works great so long as the user sticks to the list. Unfortunately, users are circumventing this by typing client IDs in the drop down. This too is ok, except for the fact that people make mistakes and type client IDs that don't exist, thus telling the computer to reference data that returns the beloved N/A# error.:(
E.g.: say clients are Tom, Dick and Sally. If you type "Sally" in the drop-down on another sheet, no problem. If you type "Sully" instead, her address, date of birth, etc will all appear as N/A#. HOW DO I PREVENT THIS ANNOYING OCCURENCE? Thank you for any help. I've attached an example with cartoon characters for demonstration.
Did that - no error message
Simon,
I've already done that - No error message. Perhaps this is a version issue; I'm working with Excel 2003. Any other ideas?