VBA query on external worksheet

[Peanuts890]

I am writing a macro to copy complete rows of data which match specific conditions from an external networked worksheet which has 500-2000 rows. The first thing I want to do is search for the first occurrence of a piece of data in column A and note the row number. I then want to go back and check this row and subsequent rows to meet other conditions. Once each row in the external worksheet is checked as valid I want to copy this entire row to my current open worksheet. Many thanks.