+ Reply to Thread
Results 1 to 5 of 5

VBA code: copy/paste data from 2 two columns into one column

  1. #1
    Forum Contributor
    Join Date
    09-10-2012
    Location
    Slovakia
    MS-Off Ver
    Excel 365
    Posts
    174

    VBA code: copy/paste data from 2 two columns into one column

    Hi friends,

    pls could you help me with macro code which should done result as is stated in attached example file? In general I need to copy Account1 from column "A" and next copy below Account2 from column "B".

    This is example and in original file there is a huge number of lines, so I can't do it manually.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA code: copy/paste data from 2 two columns into one column

    Try the attached
    Attached Files Attached Files
    Last edited by AB33; 11-19-2015 at 11:16 AM.

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

    Re: VBA code: copy/paste data from 2 two columns into one column

    Maybe:

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    09-10-2012
    Location
    Slovakia
    MS-Off Ver
    Excel 365
    Posts
    174

    Re: VBA code: copy/paste data from 2 two columns into one column

    Friends, thanks to both of you for your help. It works.

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

    Re: VBA code: copy/paste data from 2 two columns into one column

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

+ 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. [SOLVED] Create new sheets and copy/paste data based on values in a column or columns
    By quintans1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2015, 12:15 PM
  2. Replies: 5
    Last Post: 08-01-2014, 04:30 PM
  3. [SOLVED] VBA code to combine data from two different sheet columns and paste new sheet and column?
    By Chris* in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-16-2014, 03:15 AM
  4. [SOLVED] Compare two columns and copy and paste data from a third column when a match is found
    By GatorsBucs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-28-2013, 06:54 PM
  5. [SOLVED] Copy data from two columns and paste without duplicates in another column
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-22-2012, 07:56 PM
  6. VBA Code to copy data from last filled column and paste to the next available column.
    By Pavman2473 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-09-2012, 09:07 PM
  7. Code to copy data from one column and paste in at the bottom of another list
    By Winon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-12-2011, 10:20 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