Here's a good challenge for someone to work on

T

The Foreman

When typing new entries on a list is there a way to auto goto so you do not have multiple entries???????????????????????????
 
A

Arvi Laanemets

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???????????????????????????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatic indexing in footnotes - solved 0
Recover Outlook calendar entry 1
How to make repeating drop-down lists? 2
Embed the same Excel multiple times 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Copy previous record into form field 0
new v/s createObject ... IXMLDOMNodeList 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0

Top