Previous Topic Next Topic

Copy & Paste in Excel using macros

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

Réponse 1 / 1
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
22 May 2014 à 01:16
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)

Similar discussions

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

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

6 responses
What hashtags to use on TikTok?
Thomascharlesbritton -
HelpiOS -

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

4 responses