Afternoon All,
Had a look in discussions cant find what I am looking for.

Is it possible to use a macro to look for a certain portion of text in this
case "SC"
in a cell and copy the entire row to a new sheet.

Raw data is just over 2000 rows and dont want to copy and paste all
individually.

Have tried sorting the data, but due to other characters in that particular
cell cant get all SC rows together.
TIA
Ajay