Dear All,

I have an interesting problem.
I have an excel sheet with 20000 rows.
Column n contains text "Dismantle".The text "Dismantle" appearing randomly in column n.
I want a formula or macro that check the criterion in column N as "Dismantle" If "Dismantle" text is found in column n
Then Fill a color that row and then copy All "Dismantle" row to a new sheet.
The original sheet remain intact.

PLease Help

Rgds,
Aligahk06