Create VBA that types text into a column if target cell contains certain string

[ppilot]

Hi,

So I am trying to create a macro that automatically types one of two text options into a column if the reference cell contains certain text. So basically the VBA version of the following:

IF (B,2) Contains "A","B","C","D","E", or "F" then Type "ABC-Related" in (C,2)

If (B,2) doesn't contain any of those, then type "Non-ABC"

This would go until there was no more text in column B

Keep in mind would be in a 9,000 line spreadsheet, so I've tried messing around from macro some filters but it doesn't work quite right.

Thanks!