Which parts are Sheet1 and which Sheet2?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Patel" wrote in message
...
Hello,

I originally wrote this code for data that was on one sheet, but now I
want to look at data that is on Sheet 1 and if it fits the criteria
that I have listed on Sheet 2, then I will go through the j loop and
copy it. I don't know how to reference the cells in the 1st "if"
statement when they are on different sheets. Can someone please help
me?

Sub trial()
For k = 2 To 9
If Cells(k, 12) = Cells(17, 4) And Cells(k, 5) = Cells(17, 2)
And Cells(k, 5) <= Cells(17, 3) Then
For j = 1 To 26
Cells(k + 16, j) = Cells(k, j)
Next j
End If
Next k
End Sub



Thanks,
Stephen