Results 1 to 2 of 2

Thread: Trying to Copy and Paste a Filtered Column

  1. #1
    New Member
    Join Date
    Mar 2018
    Posts
    43
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Trying to Copy and Paste a Filtered Column

    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?

  2. #2
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,208
    Post Thanks / Like
    Mentioned
    68 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Trying to Copy and Paste a Filtered Column

    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
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •