Hi I've just got a macbook and am transferring an excel sheet from pc to mac using office mac 2008. It won't recognise a macro i had in the sheet - can anyone help me to put this macro in??

this is what i need

in workbook named jobs done
if column J says PAID then move the row to worksheet named jobs paid ie=

A B C D E F G H I J
1 PAID (move to sheet jobs paid)
2
3
4
5