Previous Topic Next Topic

Copy & Paste in Excel using macros

Closed
SureshPalarimath Posts 1 Registration date Wednesday May 21, 2014 Status Member Last seen May 21, 2014 - May 21, 2014 at 09:11 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - May 22, 2014 at 01:16 AM
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.
Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
May 22, 2014 at 01:16 AM
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)
0

Similar discussions

Can no longer paste text into insta
6hypnone -
Richierichmeister -

6 responses
How can I make my name text invisible in Discord
imbenmark -
imbenmark -

4 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses