I tried this code to copy the item in the columns 1,2 ,7,8,9,10 on condition that belong to match cells in columns 3,4,5,6 in same row as it show in the pic. but it didn't succeed with me.

[vba]
Dim MyRange1 As Range
Dim MyRange2 As Range
Dim cell As Range
Dim cellA As Range
Dim i As Long
Set MyRange1 = Sheets(1).Range("C1")
Set MyRange2 = Sheets(1).Range("L1")
For i = 1 To UsedRange.Rows.Count
For Each cell In MyRange1
For Each cellA In MyRange2
If cell.Value = TextBox1.Text And cell.Offset(0, 1).Value = TextBox2.Text _
And cell.Offset(0, 2).Value = TextBox3.Text And cell.Offset(0, 3).Value = TextBox4.Text Then
cellA(i, 12).Value = cell.Offset(i, -2).Value
cellA(i, 13).Value = cell.Offset(i, -1).Value
cellA(i, 14).Value = cell.Offset(i, 7).Value
cellA(i, 15).Value = cell.Offset(i, 8).Value
cellA(i, 16).Value = cell.Offset(i, 9).Value
cellA(i, 17).Value = cell.Offset(i, 10).Value
End If

Next cellA
Next cell
Next i

[/vba]