+ Reply to Thread
Results 1 to 12 of 12

Copy paste entire row different sheet column C

Hybrid View

  1. #1
    Registered User
    Join Date
    06-14-2012
    Location
    Cincinnati
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Copy paste entire row different sheet column C

    the current code will paste the rows of data in column A on the "check List". I need it the rows to start in column C instead of A on "Check List". I understand that I can't paste an entire row on "Check List" starting in column C, but don't know how to shorten the range from entirerow.

    Thank you

  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 paste entire row different sheet column C

    Did you try the suggestion in Post 4?

  3. #3
    Registered User
    Join Date
    06-14-2012
    Location
    Cincinnati
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Copy paste entire row different sheet column C

    Pasted the code in place of mine and now it only pastes the last row of the data, but it is going into column C.

  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 paste entire row different sheet column C

    Based on reading this thread. I thought you wanted it to go into Column C? Is that correct?

  5. #5
    Registered User
    Join Date
    06-14-2012
    Location
    Cincinnati
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Copy paste entire row different sheet column C

    Yes I want it to paste the row starting in column c on "check list". But there are multiple columns, and the number of rows will vary. And the new code is only copying the last row.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1