Delete cell contents based on another cell value

[BigTC]

Hello All,

Im pulling my hair out just slightly trying to find some code that removes data from cells G14 & H14 based on text criteria in cell P14. I have managed to figure out some code that works for 1 row only but require this to be a running theme all the way down the sheet.

Any help would be greatly appreciated.

Tony

 

[BigTC]

Well I gave you a answer that works but if do not think it will work without even trying then I don't know what to say.

apologies i didn't see your response with the code whilst i was replying to another one of your posts.

Yes the code works great. appreciate your help

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

apologies i didn't see your response with the code whilst i was replying to another one of your posts.

Yes the code works great. appreciate your help