VBA script to insert text in cell if a different cell in row does not contain specific txt

[Metrazal]

I have a spreadsheet with multiple rows. I need to be able to look at cells ("A:A") and if they do not contain the text "SSD" put "N/A" in column F, if they do not contain the text "PO45" put "N/A" in column G, if they do not contain the text "IC82" put "N/A" in column H, or if they do not contain the text "R12" put "N/A" in column I. (See attached file for example)

Any help is appreciated.


Thanks,

Met

[AB33]

Hi Met,
Try the attached

[Metrazal]

Wow. Very good. It is going to take me a while to decipher this and apply to my real worksheet but I really appreciate the help.

One quick question: How would I apply this to update the sheet "Sheet1" instead of the "Desired Results" sheet?

Thanks,

Met

[AB33]

Change this line of the code

Please Login or Register  to view this content.

Mind you, to save time looping I have assumed the gap in the sting is 2, not 1.
If you look at this line

Please Login or Register  to view this content.

It is assumed it is 2 null string. Watch out on your output

[Metrazal]

Thanks again.