vba formula on a filtered worksheet

[jaik22]

  ActiveSheet.Range("$A1:$W1").AutoFilter Field:=23, Criteria1:="Yes"
    
    Range("T1").Offset(1, 0).Select
    Selection.FormulaR1C1 = "=VLOOKUP(RC[-15],PV!C[-19]:C[-16],4,FALSE)"
    Selection.SpecialCells(xlCellTypeVisible).FillDown

So far, I filtered my data where W = yes, and I am trying to put that formula using offset.
It does not do anything and I do not know what's wrong with the code.

How can I make this work??

Thank you

 

[MARK858]

Do you mean something like...

ActiveSheet.Range("$A1:$W1").AutoFilter Field:=23, Criteria1:="Yes"
Range("T2:T" & Range("A" & Rows.Count).End(xlUp).Row).SpecialCells(12).FormulaR1C1 = "=VLOOKUP(RC[-15],PV!C[-19]:C[-16],4,FALSE)"

 

[jaik22]

whoa.... thank you so much!

 

[MARK858]

You are welcome