Accept/Reject values in Excel cells

[loopoo]

Hello!

I hev the following problem: I want, in a cell, to be able to select a value that is in list1, but not in list2 (list1 contains the values in list2).

Can anyone help me with that?

Thanks in advance,
Chris

 

[venkat1926]

suppose list1 is the range name for entries in column A
list2 is range name in columnC

if you run this sub the items in list 1 not in llist2 will be copied in column F
modify to suity you


Public Sub test()
Dim findc As Range
Dim cell As Range
Dim i As Integer
For Each cell In Range("list1")
With Range("list2")
Set findc = .Find(cell)
End With
If Not findc Is Nothing Then GoTo line1
cell.Copy Destination:=Range("f1").Offset(i, 0)
i = i + 1
line1:
Next
End Sub