Excel VBA - To clear contents if cell in same row contains value

[KriKri84]

Hello Geniuses,

Seeking some advice / help hence in need of some wisdom. I want VBA to clear the contents of a cell IF another cell in the same row contains 'OK'

This is the data I have:

Excel.JPG

Into some more detail: I was looking for VBA to clear the contents of the respective cell in column G if the adjacent status in column I is 'OK'
This needs to be applied to the whole active worksheet whereas if the status for that row shows 'OK' then the respective 2nd FollowUp date in the same row is not needed hence needs to be cleared.

I was currently trying to tweak the current code (found it online - not my work) but got little ahead so far:

Please Login or Register  to view this content.

Any help getting through this will be greatly appreciated.

Many thanks!

[vcoolio]

Hello KriKri84,

Is the status in Column I the result of a formula or is it just typed in when required or is it a selection from a drop down?

Cheerio,
vcoolio.

[KriKri84]

Hello vcoolio,

It is the result of a formula I created from another tab on the same workbook:

Attachment 644544

Thanks!!

[nigelog]

One way with filter

Please Login or Register  to view this content.

[vcoolio]

Hello KriKri84,

It is the result of a formula I created from another tab on the same workbook:

If that's the case, and your data set is large, I was going to suggest using autofilter but Nigelog has already done this. Test his solution and let us know how it works (test it in a copy of your workbook first).

Cheerio,
vcoolio.

[KriKri84]

Amazing! Works beautifully and it is exactly what I wanted!!

However I realized that column G needs to be visible for the code to work. Columns F / G/ H will be hidden from the user.

Is there any way we can fix this from the code? My apologies for not mentioning it earlier but I was not even aware it mattered.

Much obliged!

[Fluff13]

How about

Please Login or Register  to view this content.

[nigelog]

Please Login or Register  to view this content.

unhide and hide columns will work

[KriKri84]

Works like a charm!

Thank you so much vcoolio / nigelog!

[vcoolio]

You're welcome KriKri84 (although Nigelog did the bulk of the work on this.)

Please also acknowledge Fluff13's contribution.

Cheerio,
vcoolio.