aligahk06
03-23-2010, 11:13 PM
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
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