How to use macro to change status in column A by condition

[Adamlearnexcel]

Hi, masters

Please look at my column A, How could I use macro to do that, if status in column A is "Closed", then remain the same. if status in column A is other status rather than "closed", change that status to pending for collection advice.
Thank you so much for the help..

[MarvinP]

Hi,

Try this:

Please Login or Register  to view this content.

[AlphaFrog]

First test this on a copy of your data.

Please Login or Register  to view this content.

[Adamlearnexcel]

It works, Thank you so much. masters