If function copying row to new worksheet

[frederikpm]

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

[venkat1926]

try this macro .(the file now named "example frederick.xlsm") is returned. see second sheet
you can clear the second sheet and again run the macro for retesting.

Please Login or Register  to view this content.