Try this

[vba]

Private Sub CommandButton1_Click()
Dim mpStartRow As Long
Dim mpRow As Range
Dim MyRange1 As Range
Dim MyRange2 As Range
Dim cell As Range
Dim cellA As Range
Dim i As Long, j As Long

Set MyRange1 = Sheets(1).Range("C1")
Set MyRange2 = Sheets(1).Range("L1")

mpStartRow = UsedRange.Cells(1, 1).Row
For i = 1 To UsedRange.Rows.Count
If Cells(mpStartRow - 1 + i, "C").Value = TextBox1.Text And _
Cells(mpStartRow - 1 + i, "D").Value = TextBox2.Text And _
Cells(mpStartRow - 1 + i, "E").Value = TextBox3.Text And _
Cells(mpStartRow - 1 + i, "F").Value = TextBox4.Text Then
Cells(mpStartRow - 1 + i, "L").Value = Cells(mpStartRow - 1 + i, "A").Value
Cells(mpStartRow - 1 + i, "M").Value = Cells(mpStartRow - 1 + i, "B").Value
Cells(mpStartRow - 1 + i, "N").Value = Cells(mpStartRow - 1 + i, "G").Value
Cells(mpStartRow - 1 + i, "O").Value = Cells(mpStartRow - 1 + i, "H").Value
Cells(mpStartRow - 1 + i, "P").Value = Cells(mpStartRow - 1 + i, "I").Value
Cells(mpStartRow - 1 + i, "Q").Value = Cells(mpStartRow - 1 + i, "J").Value
End If
Next i
End Sub
[/vba]