If function copying row to new worksheet

Hi there,

I am trying to develop a benchmarking tool.

The idea is to use use a workbook with 2 worksheets, where the first is an initial screening and the second is a more thorough evaluation of the riskiest companies. Companies having an average risk rating over 3, have to be transfered to the worksheet 'complete screening'.

This implies that I need to create some kind of if function.

If companies (column B) in the sheet 'initial screening' scores above an average rating of 3 (column F), the row must be copied to the sheet 'complete screening'.

How is this possible to do in a simple way?

I have quite limited experience working with macro's, it has been several years since I touched upon it, so excuse me for my ignorance :)

Thanks
Frederik