Hi there,
I would like to be able to clear specific cell in column depending on what is in the header.
ex: If A1 =Total,
then clear content of ( A4, A5, A10 ) only.
The macro continu the search in column B, C, D......and do the same action in the other column, (ex : If B1 =Total, then clear B4,B5,B10)
Any idea !?
I would like to be able to clear specific cell in column depending on what is in the header.
ex: If A1 =Total,
then clear content of ( A4, A5, A10 ) only.
The macro continu the search in column B, C, D......and do the same action in the other column, (ex : If B1 =Total, then clear B4,B5,B10)
Any idea !?