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 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago