Attached file has solution. Plz check validation section. Plzzzzzzzzzzz praise me if that helps. hahahahaha
On Tue, Apr 7, 2009 at 1:31 PM, anil kumar <anil.4u.ku...@gmail.com> wrote: > 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 > > > > -- Thanks & Regards, Harmeet Singh --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
Book1.xls
Description: MS-Excel spreadsheet
