Isso fará o truque:
Public Sub allergy_copy()
Dim wkb As Workbook
Dim wks As Worksheet
Dim wks1 As Worksheet
Set wkb = ThisWorkbook
Set wks = wkb.Sheets(1)
Set wks1 = wkb.Sheets(2)
endrows = False
thisrow = 3
While endrows = False
If wks.Cells(thisrow, 1) <> "" Then
With wks
.Rows(thisrow).Copy Destination:=wks1.Rows(thisrow)
thisrow = thisrow + 1
End With
Else
endrows = True
End If
Wend
End Sub