Hi Guys,

I'm all new to this Macros and when trying to create the code to find data in a specific row and select the data on the same rows to transfer to another workbook I seem to be getting continuous errors.

The objective is for the button to be clicked, analyze workbook1, for example, in column L for number 1. If the number 1 is in this column it would select the rows affiliated with it.

When the rows are selected, I want to copy this data to another workbook on a specific row (hopefully populates all the other rows into new rows).

Could any assistance be given in regards? I would much appreciate it.

What I have so far but i's not reading.


Private Sub CommandButton1_Click()

Dim FindRow As Range

Set FindRow = Range("L:L").Find(What:="302", _
After:=.Cells(.Cells.Count), _
LookIn:=xlValues, _
LookAt:=xlWhole, _
SearchOrder:=xlByRows, _
MatchCase:=False)

If Not FindRow Is Nothing Then
FirstRow = FindRow.Row
End If

End Sub