Trying to Copy and Paste a Filtered Column

ctackett6407

New Member
Joined
Mar 18, 2018
Messages
46
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

Well-known Member
Joined
Dec 3, 2018
Messages
9,614
Office Version
2007
Platform
Windows
Run this macro:

Code:
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
 

Forum statistics

Threads
1,085,089
Messages
5,381,649
Members
401,747
Latest member
Jtvan

Some videos you may like

This Week's Hot Topics

Top