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".
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.