Move/append to other file/sheets macro
Hi If anyone please help.
I have two sheets
1. One is source and other is master.
2.Master sheet have 10 sheets and source have 7 sheets.
3.Source file with 7 sheets are updated monthly and need to be pasted to master sheets(same name 7 sheets on master ).
4. While pasting data from source to master, data on each sheet should be pasted without headers and in the end of the master sheet.(e.g master sheet have 10 rows then paste should be from a11)
I've uploaded the sample xcel files.
Can any one please help me to write the code. I 've attached the sample xls, in these 1,2,3,4 from source sheet should be appended over to 1,2,3,4 of the master sheet excluding headers.
thanks
Attachment | Size |
---|---|
Master.xlsm | 17.48 KB |
source2.xlsm | 17.48 KB |
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago