Currently I have a work book with lots of data in it that im trying to make a little easier to manage.
The logic im trying to use goes along the lines of
If worksheet 1 f2,F809 = W1 then copy that row into worksheet 2. If it doesn't then check the next row.
Is this possible at all? I did have a rudimental equation but I cant figure out the copy part of it. I also need this to be copied down the coloum in the second worksheet.
The equation I have so far is

=IF('W1'!F2:F28="W1","copy row","")

Obviously this hasn't worked.


Any help would be appreciated