 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2007ALERT IF TRY TO ENTER SAME SECOND TIME
I need to enter data in about 10 columns from hard copies I get daily. One of these columns will be a key (alphanumeric) that defines a job. I may receive other hard copies on other days of that same job. I don't want to enter the data a second time. How can I have the sheet alert me if I try to enter the key again? How about Conditional Formatting? best wishes  SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email >I need to enter data in about 10 columns from hard copies I get daily. One >of these columns will be a key (alphanumeric) that defines a job. I may >receive other hard copies on other days of that same job. I don't want to >enter the data a second time. How can I have the sheet alert me if I try >to enter the key again? Hi Bernard, Please explain. Thanks. > How about Conditional Formatting? > best wishes [quoted text clipped - 3 lines] >>want to enter the data a second time. How can I have the sheet alert me >>if I try to enter the key again? You can data validation for this. Suppose the range in question is A1:A10 Select the range A1:A10 Goto the menu Data>Validation Allow: Custom Formula: =COUNTIF(A$1:A$10,A1)<=1 Ok Whenever you attempt to *manually* enter a duplicate value a message box will pop up and alert you. This can be defeated by copying/pasting and/or drag/drop. Biff >I need to enter data in about 10 columns from hard copies I get daily. One >of these columns will be a key (alphanumeric) that defines a job. I may >receive other hard copies on other days of that same job. I don't want to >enter the data a second time. How can I have the sheet alert me if I try >to enter the key again? WONDERFUL! Now, please explain the formula. I just can't understand how it works. Thanks > You can data validation for this. > [quoted text clipped - 20 lines] >>want to enter the data a second time. How can I have the sheet alert me >>if I try to enter the key again? Never mind, I figured it out. Thanks very much for the tip. > WONDERFUL! Now, please explain the formula. I just can't understand how > it works. [quoted text clipped - 25 lines] >>>want to enter the data a second time. How can I have the sheet alert me >>>if I try to enter the key again? You're welcome! Biff > Never mind, I figured it out. > Thanks very much for the tip. [quoted text clipped - 28 lines] >>>>want to enter the data a second time. How can I have the sheet alert >>>>me if I try to enter the key again?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.