Pulling data to a master worksheet using VBA

MrCrimmy

New Member
Joined
Sep 26, 2014
Messages
14
Hi all! Still having trouble with this :(

I wonder could someone help me, I am trying to produce an activity analysis database for my team. We track our activity in our own spreadsheets, in total there is 16 of them. Each process has a subset of different activites, an example of which can be seen below: file path P:\LabGroup\ActivityTracker\Activity Analysis - Bryan.xlsx.
ProcessActivityTime(hours)
BAUMeeting1
DevelopmentResearch5
BAUSafety1
ExpansionTraining2

<TBODY>
</TBODY>





This is done for each week so each workbook has about 6 sheets one for each week. This is then collected in a cumulative sheet as follows:

ProcessActivityTime
BAUMeetings1
Safety1
DevelopmentResearch5
Experiments0
ExpansionTraining2
Purchasing0

<TBODY>
</TBODY>


This data is gathered using SUMIFS functions.

What I need to do is to collect the gathered data into a master cumulative sheet which will have table like the one above for each person. (Path P:\LabGroup\ActivityTracker\Cumulative Activity Analysis.xlsx.


Is there anyway I could use <ACRONYM title="visual basic for applications">VBA</ACRONYM> or some sort of macro to open each file copy out their cumulative data and insert it into the master sheet for review by our team leader?

Any help anyone could offer any assistance I would greatly appreciate it.

Kind Regards

Bryan​
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Watch MrExcel Video

Forum statistics

Threads
1,109,536
Messages
5,529,422
Members
409,875
Latest member
Khushal Bisht
Top