+ Reply to Thread
Results 1 to 3 of 3

Copy all cells in column that contain data & paste to first empty row of another column.

  1. #1
    Forum Contributor
    Join Date
    01-06-2012
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    165

    Copy all cells in column that contain data & paste to first empty row of another column.

    Hi,

    Basically what I'm trying to achieve is to create a macro that will copy data from multiple columns over to the next empty blank rows in another column. Here's an example:

    A B C D E F G H I J K
    a2 1
    a1 1
    b2 1 c3 1 bc4 1

    Any data in columns D:E, G:H, J:K would be copied over to the first empty cells in columns A:B.

    Any ideas as to how I might get started would be very much appreciated, thanks in advance.
    Last edited by BPSJACK; 09-02-2014 at 08:17 AM.

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Copy all cells in column that contain data & paste to first empty row of another colum

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    01-06-2012
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    165

    Re: Copy all cells in column that contain data & paste to first empty row of another colum

    Works like a charm, phenomenal work! Thanks!

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Copy all cells in column that contain data & paste to first empty row of another colum

    You're welcome. Glad to help out and thanks for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. copy & paste last column from pivot table to next empty column
    By kitrak2 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2013, 06:57 PM
  2. Replies: 5
    Last Post: 03-02-2013, 04:22 PM
  3. Vba - find next empty column, insert column, copy paste values & copy paste formulas
    By DoodlesMama in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2012, 12:43 PM
  4. Replies: 3
    Last Post: 08-28-2012, 10:09 AM
  5. Copy and paste data if row in Column N is empty.
    By Hopper in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-31-2009, 03:25 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1