Paste Filtered Sheet

[sugargenius]

I have a sheet of rates. Column A is the rate. Column B is the effective date. Supposed I wanted to escalation the rates for 2020 by 5%. My first approach would be to filter the date column for 2020 and then enter a formula in column C like, =A2*1.05. Then I would copy column C and paste values in Column A. However, when I attempt this exact approach, the paste doesn't work. The paste seems to ignore the filter and affect rows that are outside the filter condition.

Is there a way to get paste to work in a filtered sheet?

 

[Fluff]

Try this for the paste

Sub CopyValues()
   Dim Rng As Range
   For Each Rng In Range("C:C").SpecialCells(xlVisible).Areas
      Rng.Offset(, -2).Value = Rng.Value
   Next Rng
End Sub