Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
still haven't archive anything
eg.
sheet1
column(D)
4
6
9
14
67
5
43
32
sheet2
column(c)
_
_
_
_
_
_
_ (Empty cells)
when i give a value to any cell of sheet2.column(c), it must me compared with all the values of sheet1.column(d) and return a message if equal
with data validation it returns an error when I try the formula with a range of cells
if you can provide me a sample code it would be great
thanks in advanced
attach an example workbook!
See attached.
Enter any value in any of the bordered boxes in Column C. If the value exists in Sheet2, column D, you will get a message...
To extend the validation down column C... just copy any cell with validation.. select the range you want to copy to and go to Edit|Paste Special.. select Validation.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
thanks for all of your help
i finily did it...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks