+ Reply to Thread
Results 1 to 4 of 4

How to copy from source workbook and pasting at first empty row in destination workbook

  1. #1
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    How to copy from source workbook and pasting at first empty row in destination workbook

    I am copying anywhere from 15-25 rows from 8 separate workbooks that I am merging into one workbook. Right now I just copy/paste them far enough apart and then delete the empty rows, but there must be a better way. Snippet of my code is this so you can see what I mean when I say I just paste them far enough apart so they can't overlap.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: How to copy from source workbook and pasting at first empty row in destination workboo

    Please Login or Register  to view this content.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  3. #3
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Re: How to copy from source workbook and pasting at first empty row in destination workboo

    Ah, that does make sense now doesn't it! I am slowing learning the Rows.Count and xlUp. I can use it for copying, but pasting was a new one. Thanks!

  4. #4
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: How to copy from source workbook and pasting at first empty row in destination workboo

    you are welcome
    thanks for the reps and for marking thread solved

+ 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. Replies: 0
    Last Post: 07-21-2015, 02:35 AM
  2. [SOLVED] Copy filename of source workbook to specific cell in specific tab in destination workbook.
    By MagicMan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2015, 10:29 PM
  3. Replies: 2
    Last Post: 06-09-2014, 11:33 AM
  4. VBA Copy Paste Cuts From Source, Sends to Ether - Not To Destination Workbook
    By jcaynes in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2014, 11:05 AM
  5. Replies: 0
    Last Post: 10-11-2012, 12:26 PM
  6. how to copy succeeding rows from source workbook to destination w.
    By chris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-08-2005, 10:06 AM

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