Copy & Paste in Excel using macros [Closed]

Report
Posts
1
Registration date
Wednesday May 21, 2014
Status
Member
Last seen
May 21, 2014
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
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)

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!