software

Hi All,

I want to clear out the value in the certain row when it meet the
certain criteria. Let say if the row in column C = quot;Cancelquot;, it will
clear out the contents in column E amp; F.
I also need have a input that allow user to start select which range
and row their want to start out.EXAMPLE:

BEFO

_Column_C___Column_E__Column_F_
Cancel 10 20
New 10 20
Cancel 10 20

AFTER:

_Column_C___Column_E__Column_F_
Cancel
New 10 20
CancelHope you guys can help me to solve out this problem.Thanks amp; Regards,
Sharon--
sharon2006
------------------------------------------------------------------------
sharon2006's Profile: www.excelforum.com/member.php...oamp;userid=30173
View this thread: www.excelforum.com/showthread...hreadid=522976