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

Claus,

I have copied that into vba but nothing seems to of happened. I have saved the spreadsheet successfully but as i said there is no change to what im seeing on the other sheets.