Macro for Appending Data without Header to a database with header

I am facing problem to append 1st batch of data without Header to a empty database with header. After that, 2nd batch of data will need to be appended after the last row of 1st batch data.

Could anyone help me on the macro?

Hi,
1. It's a Spreadsheet database.
2. The raw data contains same structure as the database. I have run another macro to manipulate the data.
3. The data come from another workbook.

The macro below is to append the raw data to the database.
However the command in red color will have error when the database with header is empty.
Let's say 1st day, I need to start to add my raw data to a new database with header.
2nd day onwards, I need to append new raw data to the database with contains the 1st day raw data.
The following code in red not working.

Rows ("2.2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Workbooks.Open Filename:="C:\Master.xls"
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
ActiveSheet.Paste

Hi

for the code in red try

Please Login or Register  to view this content.

Assumes that you will automatically open to the sheet that will receive the data.


rylo

Please read forum rules below and then wrap your code

VBA Noob