Macro to add a zero to a cell, based on the value in another column

[JohnnyBoyxxx]

I have 2 columns called 'Visibility' and 'Status'.

Status column has text values that are either 'Matching' 'Non-Matching' 'Matching and Updated' or 'New Row'
The Visiblity column needs to updated based on these values in the status column.

'Non-Matching' to represented by a '0' in the visibility, the other 3 text values to be represented by the number '4'

I want to be able to run a macro to make this happen.

Would appreciate any help in making this work.

Regards
John

[mehmetcik]

You should have posted a sample workbook.

This will get you started.

I am assuming you are using columns A and B

Please Login or Register  to view this content.

[JohnnyBoyxxx]

Perfect, absolutely what i needed, first time straight out of the box, N1 Mehmetcik, Thank you.
Spent a good part of the day trying to sort this out, thought i'd come here and see if someone could help.
I see you posted the reply within 20 mins of my post going live.
Really nice to wake up to find this resolved, feels like i've had a visit from the 'Excel fairy'.
Anyway, (going off on one there a bit), many thanks, very much appreciated, now onto the next problem of the day.