VBA code to populate text in another column

[KMJM2019]

Hello,
I've asked a similar question, but I keep getting errors and I'm not sure why. I have to use VBA because I'm running a daily report that changes constantly, and I've been asked to automate everything, including things that would be easy with regular Excel formulas. Anyway, I need to reference two columns, then have another column populate with text. For example, column M has a code "ABC", and column L says "not reviewed". I need column O to then spit out "email Kevin". It seems like the problem is happening when both of these criteria aren't met, the program just stops/gets ignored/doesn't run, I'm not sure which. This is the last part of a much larger program, and everything else has been working great, thanks to Mr. Excel!

 

[Joe4]

Please post the relevant section of code that you have so we can help you debug it.

 

[KMJM2019]

Sub MM2() 
    Dim lr As Long 
    lr = Cells(Rows.Count, "J").End(xlUp).Row 
    Range("O2:O" & lr).Formula = "=IF(J2=""ATO"",""Automated"",IF(AND(J2=""PRD"",L2=""waiting""),""Manual"",""""))" 
End Sub

This is the part of the code, all it does is put this formula in EVERY column instead of just one. Thank you!

 

[Joe4]

The formula in your VBA code does not seem to match your original description.
Can you give us an example of your data and let us know exactly what you expect to happen, and what is actually currently happening with your current VBA code?