Clear data in row
 

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 = "Cancel", it will
clear out the contents in column E & 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
Cancel


Hope you guys can help me to solve out this problem.:)


Thanks & Regards,
Sharon


--
sharon2006
------------------------------------------------------------------------
sharon2006's Profile: http://www.excelforum.com/member.php...o&userid=30173
View this thread: http://www.excelforum.com/showthread...hreadid=522976