vba code to display multiple rows in excel : I want to display multiple rows with same name in excel sheet that I have created using vba code.. I have created a textbox in my excel sheet 1 and when I enter a name in the text box and click search button I want the multiple rows of the same person to be displayed in excel sheet 3..

Code:
I have created the excel sheet called "List" and the data in there is

NAME     CITY

LAKHA   LONDON
KIKI    US
LAKHA   US

I have a code here.

    Sub finddata()
    
    Dim erow As Long
    Dim ws As Worksheet
    Dim lastrow As Long
    Dim count As Integer
    
    lastrow = Sheets("List").Cells(Rows.count, 1).End(xlUp).Row
    
    For x = 2 To lastrow
    If Sheets("List").Cells(x, 1) = Sheet1.Range("E7") Then
    Sheet3.Range("A2") = Sheets("List").Cells(x, 1)
    Sheet3.Range("B2") = Sheets("List").Cells(x, 2)
    
    End If
    
    Next x
    
    End Sub
    
    Sub printdata()
    
    Sheet3.Range("A1:B2").PrintPreview
    'Sheet3.Range("A1:B2").PrintOut
    End Sub
    
    Sub Clear_Cells()
    
    Sheets("Sheet3").Range("A2:B2").ClearContents
    Sheets("Sheet1").Range("E7:E7").ClearContents

End Sub

But this only displays one row at a time...

Immediate answers please. I am in deadline...
