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?
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,100
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
 

Watch MrExcel Video

Forum statistics

Threads
1,095,404
Messages
5,444,265
Members
405,278
Latest member
Rashford

This Week's Hot Topics

Top