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