VBA code help to populate text in a specific column based on another column condition

[KMJM2019]

if any row in column J that = ATO then I need every row in column O to populate "Automated". Also if any row in column J = PRD and any row in column L = "waiting" then I need every row in column O that satisfies both criteria to = "Manual".

 

[Michael M]

Why VBA ?
formula in column O

=IF(J1="ATO","Automated",IF(AND(J1="PRD",L1="waiting"),"Manual",""))

drag down as required

 

[KMJM2019]

Hi Michael M,

Thank you for your response. I am looking for a VBA code because there is a report that I run daily, and the amount of data differs. I am tasked with automating this and have already coded a lot of data based on similar conditions. Since the rows change I need to hard code a VBA formula into a macro to auto populate this. Can I do that with the IF statement or would I have to copy and paste this every time? My goal is to set a formula so I run the macro and do not have to manually enter anything. Any help with a VBA code would be very much appreciated.

Thank you!!

 

[Michael M]

Ok

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