Copy & Paste in Excel using macros

Closed
Posts
1
Registration date
Wednesday May 21, 2014
Status
Member
Last seen
May 21, 2014
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Dear Friends,

I have a interesting query about the heading.
I have a master excel file, in which I want to copy the content of the another Excel file which I get as a daily report.
For the 365 days, all daily report should be copied to the master page, one day after the another, But I don't need the headings, only data has to be copied to the next available blank row.
Note: Every day report will have the same heading and same number of rows.

Kindly help me.

Thanks in advance.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
RECORD macro and then EDIT IT.

you can resize the file the code will be something like this

set r=range("A1").currentregion
r.resize(r.rows.count-1).copy _ worksheets("MASTER").cells(rows.count).end(xlup).offset(1,0)