I have a worksheet that holds records for clients, stored with their surname. On another sheet a new record can be entered, with their surname being entered in cell K4.
I'd like to have users be able to either type a new surname, or select one previously used from the stored records. Is data validation what I need to use? When I've used data validation previously it has included any duplicate surnames as duplicates in the drop-down list, triplicates as triplicates and so on. What I really need is the drop-down list to look more like the autofilter drop down list - where duplicates are ignored, and the range of surnames is constantly increased as more records are added.
How best do I go about this?
Thanks.
I'd like to have users be able to either type a new surname, or select one previously used from the stored records. Is data validation what I need to use? When I've used data validation previously it has included any duplicate surnames as duplicates in the drop-down list, triplicates as triplicates and so on. What I really need is the drop-down list to look more like the autofilter drop down list - where duplicates are ignored, and the range of surnames is constantly increased as more records are added.
How best do I go about this?
Thanks.
