How to copy down from 2 columns
Results 1 to 8 of 8

Thread: How to copy down from 2 columns

  1. #1
    New Member
    Join Date
    Jan 2019
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to copy down from 2 columns

    Hi,

    I have data in column D, and data in column E. I want to move this to column F (for printing) so that it runs

    D1
    E1
    D2
    E2
    D3
    E3

    Etc.

    I can pull the data D1 into F1, and E1 into F2, but when copying down, it does it like so:

    D1
    E1
    D3
    E3
    D5
    E5

    Is it possible to have it so that the missing ones are included?

  2. #2
    Board Regular mumps's Avatar
    Join Date
    Apr 2012
    Location
    Toronto, Canada
    Posts
    8,088
    Post Thanks / Like
    Mentioned
    85 Post(s)
    Tagged
    5 Thread(s)

    Default Re: How to copy down from 2 columns

    Try this macro:
    Code:
    Sub Pumperkin()
        Application.ScreenUpdating = False
        Dim LastRow As Long, rng As Range, x As Long, y As Long: y = 1
        LastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
        For x = 1 To LastRow
            Cells(y, 6).Resize(2) = WorksheetFunction.Transpose(Cells(x, 4).Resize(, 2))
            y = y + 2
        Next x
        Application.ScreenUpdating = True
    End Sub
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    New Member
    Join Date
    Jan 2019
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to copy down from 2 columns

    Well thanks so much - after fiddling trying to work out how on earth to use macros, I managed to get it to work. You are a star

  4. #4
    Board Regular mumps's Avatar
    Join Date
    Apr 2012
    Location
    Toronto, Canada
    Posts
    8,088
    Post Thanks / Like
    Mentioned
    85 Post(s)
    Tagged
    5 Thread(s)

    Default Re: How to copy down from 2 columns

    You are very welcome.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  5. #5
    New Member
    Join Date
    Jan 2019
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to copy down from 2 columns

    Quote Originally Posted by Pumperkin View Post
    Well thanks so much - after fiddling trying to work out how on earth to use macros, I managed to get it to work. You are a star
    Hi, Just to follow on from this, I now have data in columns A through to F, that I wish to convert like this:

    A1
    B1
    C1
    D1
    E1
    F1

    These are addresses - I have tidied them as much as I can but can't how to modify the previous Macro (and not quite sure if it's the same thing).

    Any help gladly received.

  6. #6
    Board Regular mumps's Avatar
    Join Date
    Apr 2012
    Location
    Toronto, Canada
    Posts
    8,088
    Post Thanks / Like
    Mentioned
    85 Post(s)
    Tagged
    5 Thread(s)

    Default Re: How to copy down from 2 columns

    Can you post a screen shot of what your data looks like? Section B at this link has instructions on how to post a screen shot: https://www.mrexcel.com/forum/board-...forum-use.html Alternately, you could upload a copy of your file to a free site such as www.box.com. or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Include a detailed explanation of what you would like to do referring to specific cells, rows, columns and worksheets. If the workbook contains confidential information, you could replace it with generic data.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  7. #7
    New Member
    Join Date
    Jan 2019
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to copy down from 2 columns

    Quote Originally Posted by mumps View Post
    Can you post a screen shot of what your data looks like? Section B at this link has instructions on how to post a screen shot: https://www.mrexcel.com/forum/board-...forum-use.html Alternately, you could upload a copy of your file to a free site such as www.box.com. or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Include a detailed explanation of what you would like to do referring to specific cells, rows, columns and worksheets. If the workbook contains confidential information, you could replace it with generic data.
    Thanks Mumps. I managed to sort it a different way, by indirect reference and copying across

  8. #8
    Board Regular mumps's Avatar
    Join Date
    Apr 2012
    Location
    Toronto, Canada
    Posts
    8,088
    Post Thanks / Like
    Mentioned
    85 Post(s)
    Tagged
    5 Thread(s)

    Default Re: How to copy down from 2 columns

    Glad it worked out.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

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
  •