Trying to Copy and Paste a Filtered Column

[ctackett6407]

I know I cannot be the first to try this; however, I cannot figure out the search terms to find something that helps me.

I have filtered column K and L so that only blanks show.

I want to take all the values of column J and copy them into column L

the problem is that it only pastes hit and miss values.

Any solution that anyone know of to fix this?

 

[DanteAmor]

Run this macro:

Sub Copy_Paste_Filtered_Column()
  Dim i As Long
  For i = 2 To Range("J" & Rows.Count).End(xlUp).Row
    If Cells(i, "K").Value = "" And Cells(i, "L").Value = "" Then
      Cells(i, "L").Value = Cells(i, "J").Value
    End If
  Next
End Sub