+ Reply to Thread
Results 1 to 2 of 2

Copy Column in Sheet 1 and Paste into First Available Column on Sheet 2

  1. 07-29-2011, 07:00 AM #1
    johndoh453
    johndoh453 is offline
    Registered User
    Join Date
    06-07-2011
    Location
    boston, ma
    MS-Off Ver
    Excel 2003
    Posts
    22

    Copy Column in Sheet 1 and Paste into First Available Column on Sheet 2

    Hello.

    I am looking for a macro that can copy data from Sheet1, for example cells C3:C142, and paste them into the first available column in Sheet 2, starting at row 5.

    I would like the paste to do a paste special values because the data from Sheet 1 will change often but the Sheet2 data is a summary. That is why I would like it to find the next available column and paste so that I can look at previous data along with current data. Thanks.
    Last edited by johndoh453; 07-29-2011 at 07:42 AM.
    Reply With QuoteRegister To Reply
  2. 07-29-2011, 07:42 AM #2
    johndoh453
    johndoh453 is offline
    Registered User
    Join Date
    06-07-2011
    Location
    boston, ma
    MS-Off Ver
    Excel 2003
    Posts
    22

    Re: Copy Column in Sheet 1 and Paste into First Available Column on Sheet 2

    Figured it out. Was just missing a few small things.

    Sub CopyDataToTables()

    Dim Dest As Range

    Sheets("Initial Pull").Range("C3:C142").Copy
    Set Dest = Sheets("HCV Summary").Cells(5, Columns.Count).End(xlToLeft).Offset(0, 1)

    Dest.PasteSpecial xlPasteValues

    End Sub
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1