Hi, I"m trying to create coding that says, filter column 3 for anything other than N/A's, if Payout is populated, enter Yes in those columns of AA, if Takeover, enter Yes in column AC. I don't have an IF formula either, but that's what I would like.

When I enter the code below, it's entering the word Yes in cell AA2, which is the header row.

Code:
With Windows("Rental Rec.xlsm")
    Sheets("Owned").Select
     lRow = Cells(Rows.Count, "G").End(xlUp).Row
     With Range("a2:bh" & lRow)
            .AutoFilter
             .AutoFilter Field:=3, Criteria1:="<>#N/A"
Range("AA4:AA" & lRow).SpecialCells(xlCellTypeVisible) = "Yes"
'it didn't copy all the way down, short 8 rows, giving two different formats for dates, as well,
'want to say, if data in column c enter current date in column aj (date should be 15th of current month)
With Selection
Range("aj3:aj" & lRow).Value = Now