dear friends,

problem is: i have a big list of names is sheet2 and i have some final list in sheet 3.
i want to write a macro, which , when i click that it first look the final list, then come to sheet2 and keep the name which are exist in final list only rest all need to delete.

i am using vlookup function but facing problem in it.

some one give me idea on how to ??????

my code goes like this....

Sub match()
    
    Dim value1 As String
    Dim value2 As Range
    
    Set value2 = Sheets("Sheet3").Range("A1: A11")
    
    Range("A1").Select
    value1 = Range("A1").Value
    If Not WorksheetFunction.VLookup(value1, value2, 1, 0) = value1 Then
    Rows("1:1").Select
    Selection.Delete Shift:=xlUp

    End If
    
    Sheets("Sheet2").Select
    
 
End Sub