Hi,
I am trying to copy data from one sheet to another depending on a certain data match. i am geeting error 438
below is the code
Private Sub CommandButton1_Click()
For x = 8 To 1500
Dim a As Integer
Dim b As String
Dim c As String
a = Sheets("New...