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.
Bookmarks