On Friday, October 2, 2015 at 9:54:45 AM UTC+1, wrote:
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

Clause,

Thanks verymuch for the help, The script is working fine now. Thanks very much for all your help.

Chris