I need a macro that will cut and paste all values in dark blue and red text
over to a new worksheet in the workbook (or basically any text that is not
black).

The first row of data starts at row 9 and finishes at row 9116.

Any help or advice would be greatly appreciated.

Regards,

Simon.