Formula to paste row into another sheet?

[kellyfirth]

Hi there, I've found possible solutions for this problem using a macro, but ideally I'd prefer to use a formula if possible..?

I have a load of data in Sheet1 and if it says: 'CFIM' or 'CBED' in column G, then I want it to paste that entire row into Sheet2. I want this to occur for all rows on the spreadsheet.

Is this possible at all..?



EDIT: I have solved this for my spreadsheet now. No help needed