validating data.....without repeating!!
Posted by zen on June 06, 2001 2:39 AM
i've been putting together a master data sheet with peoples names telephones login id's etc., i'm using 'list' validation on login's, how can i make sure that someone doesn't put the same one i twice for different people, i've used conditional formating in the short term, to highlight red if the countif is > 1,
i'd rather some form of error message to alert the user that it isn't valid. ideally it could ask the user if they want to keep the number or change it, in both the new input and the old.
any help is most definately appretiated
p.s. i still want to use 'list' validation