+ Reply to Thread
Results 1 to 3 of 3

Pasting Copied Cells into Column Right After Last Column with Data

  1. #1
    Forum Contributor
    Join Date
    04-20-2011
    Location
    New York, New York
    MS-Off Ver
    Excel 2010
    Posts
    160

    Pasting Copied Cells into Column Right After Last Column with Data

    Hello,

    I want to create a macro that copies cells starting with “ N3 ” to the very last cell with data within Column N and then pastes the copied cells in the column right after the last column that contains data starting in row 3. In addition, getting rid of the marching ants would be great as well.

    As part of this post I am providing you with a workbook that visually shows you what I am looking for. In the first worksheet of this workbook named “Before Macro Execute” just simply shows you what the data looks like before it will be manipulated by the macro. The second worksheet is named “After Macro Execute” and it shows obviously the results that I’m looking for. I highlighted cells in column N just to make it easier to spot in both worksheets. Also, in the worksheet "Before Macro Execute" the last column with data is "Q", but this might not be the case every time it could easily be column "S".

    Thanks
    Attached Files Attached Files
    Last edited by boldcode; 09-24-2013 at 02:36 PM. Reason: Solved

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

    Re: Pasting Copied Cells into Column Right After Last Column with Data

    Try the attached.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    04-20-2011
    Location
    New York, New York
    MS-Off Ver
    Excel 2010
    Posts
    160

    Re: Pasting Copied Cells into Column Right After Last Column with Data

    AB33,

    Works great, thank you for your time!

    - BC

+ 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] Copy Entire column and then insert the copied cells below the original
    By awagenhurst in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-18-2013, 04:52 PM
  2. Prevent copying and pasting a cell from a column with data validation to another column
    By kieranoduill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2013, 10:02 AM
  3. [SOLVED] Pasting data into a column without overwriting certain cells?
    By BillDoor in forum Excel General
    Replies: 2
    Last Post: 02-05-2013, 04:29 PM
  4. Help for adding static date in column B on import/pasting of data in Column A
    By Parijaat in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2013, 05:34 AM
  5. Extracting data from column based on specific criteria and pasting into new column
    By vanvalkenburg in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-14-2012, 10:26 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