T The Foreman Nov 7, 2003 #1 When typing new entries on a list is there a way to auto goto so you do not have multiple entries???????????????????????????
When typing new entries on a list is there a way to auto goto so you do not have multiple entries???????????????????????????
A Arvi Laanemets Nov 7, 2003 #2 Hi P.e. for column A Select the column Data.Validation.Custom Formula=COUNTIF(A:A,A1)<2 OK -- (When sending e-mail, use address (e-mail address removed)) Arvi Laanemets The Foreman said: When typing new entries on a list is there a way to auto goto so you do Click to expand... not have multiple entries???????????????????????????
Hi P.e. for column A Select the column Data.Validation.Custom Formula=COUNTIF(A:A,A1)<2 OK -- (When sending e-mail, use address (e-mail address removed)) Arvi Laanemets The Foreman said: When typing new entries on a list is there a way to auto goto so you do Click to expand... not have multiple entries???????????????????????????
