Hello! First time posting here. I know very little VBA but am usually I'm able to find what I need by scouring the web. Unfortunately, this is a fairly specific problem and I can't find it on my own. I was hoping someone nice could help me out here.

WHAT I NEED:

If D3A, D3B, D6A, or D6B appear anywhere in a cell in column AB, and there is data in its adjacent cell in column AC, then add 001 to the front of the data in the cell in column AC.


Thank you!

-Adam