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

Reply via email to