Macro to Copy/Paste from multiple Workbook

p9j123

Active Member
Joined
Apr 15, 2014
Messages
275
Hello Experts,

I need help on the following.

I have a masterfile.xlsx that collects data from multiple excel file that were stored in C:/Source/Week 1.


I need a macro that will open each and every excel file from C:/source and copy the content from Summary Report Sheet columns R7:W? and paste it to the next blank row on masterfile.xlsx.


Condition:


1. Path should be captured from cell (A1) so that I can change it depending on the week period folder.
2. Macro will only copy the rows until the word "Reserve" so for exaxmple "reserve is on R12, then the macro will only copy R7:W11.
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Watch MrExcel Video

Forum statistics

Threads
1,108,973
Messages
5,525,986
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top