A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
[cut]
However, in any given entry I want to be able to either pick from the list of previous addresses (to save time and errors in re-typing an existing address) or to be able to enter a new address if it doesn't already exist on my list. It isn't important that any new address entered has to automatically add to the existing list of addresses; the important thing is to be able to either pick from the existing list or enter new data in the same cell without getting the Data Entry Error message.
Can anyone give me a steer on whether this is possible and, if so, how to achieve it?
Hi Hebe(GB),
Try:
On the Ribbon | Data tab | Data Validation |
Settings | Data validation settings | Error Alert tab | uncheck Show error alert
===
Regards,
Norman