Hello,

I have a worksheet that is used to record incidents. We have a conditional format to recognize if the same name is entered into column C (repeat offender etc). I would like to pull the ENTIRE row of this (repeat offender) to a new sheet. Basically there are columns A:M. The Name is column C and the worksheet goes from 2:300. I can NOT use VBA, without an explanation, but I have tried every formula I can think of and found nothing. The conditional formatting is set to turn the Duplicate cells in column C RED (highlighted) with black text. I only want to pull it to the new worksheet if the C cell is highlighted red fill. Can anyone help me with this?