Hi,
Please check the attached, Have done it thru validation Colum B:B can be hidden if required Regards Sathish Jalendran From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of anil kumar Sent: 07 April 2009 01:31 pm To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Data should not be Duplicate - Using validation in Excel Hi All, i would appricate you to all. i have a query related to Excel Example: A1 100 A2 200 A3 300 A4 100 A5 250 A6 200 A7 300 ... A8 in above example we have data in cells A1 to A8 which have corresponding value. now i want is that while any user input data of Column A then there should pop up a message for duplicate entry, can we do this through the Validation i don't want to use any macro for this. please do help on this. -- Thanks & Regards Anil Kumar 9213901798 --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
Validation.xls
Description: MS-Excel spreadsheet
