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
Bookmarks