Pasting multiple data sets *bypassing clipboard* without a header and in order

**** Ok, New problem***

I have all of the code working, however, there is so much data that it fills up my clipboard! This means there are two to thrtee times that the program asks if I want to keep or clear the data from the clipboard. I know there is code following the syntax selection.copy destination:=Sheets."whatever" but I can't get it to work with some more specific criteria. Namely, I want to copy the selected data to the first empty row in a different workbook. As we can see in the code from the first reply, I have it coded to select the data in the first datasheet and then copy/paste it to the new workbook bypassing the clipboard. The code then says to select the data from datasheet2, modify the selection to not include the top (header) row and then copy it to the clipboard, and from there paste it below the first set of data from datasheet1 pasted in the new workbook.

Having trouble trying to get it to bypass the clipboard though... Here's how far I've gotten before using my "bang head here" spot on the wall (Note that I tried clearing the clipboard with the cutcopymode=false command... It didn't work):



Original post:******
Hi all,

Im trying to combine some sets of information and am having some difficulty with the code. It continually errors no matter what I've tried to do which means I don't know what I'm doing

Here's the quandry: I have multiple workbooks with sheets called "Before" and "After". Each of these sheets has data in columns A:BAY with row 1 being a header. There is no set amount of rows used, some have 500, some have 1500. I want to take the first sheet and paste it into a combined worksheet called HomeBefore including the header. The second "Before" sheet from the next workbook, I want to copy all of the data except the header placing it below the data from the first paste.

Code legend:
Datasheet1 = The first workbook with the "Before"/"After" sheets
DataSheet2 = The second workbook with the "Before"/"After" sheets
wsMaster = The workbook where all of the data is being combined

Note that there is another macro which determines which sheets to use (fills in file names), and there is a snippet in this code that basically says "If that file slot is blank, skip to the next"

The copy/paste from Datasheet1 works fine and I can copy the code down to other datasheets but it overwrites the previous data each time.

Here's what I have so far:

Please Login or Register  to view this content.

Any suggestions?

..........
Edited to take out solution to previous quandry..