Accept/Reject values in Excel cells

loopoo

New Member
Joined
Nov 10, 2005
Messages
43
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
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
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
 
Upvote 0

Forum statistics

Threads
1,214,657
Messages
6,120,776
Members
448,991
Latest member
Hanakoro

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top