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

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Watch MrExcel Video

Forum statistics

Threads
1,114,084
Messages
5,545,870
Members
410,711
Latest member
Josh324
Top