VBA macro to extract data from multiple workbooks into a master workbook

**garfield0304** · 01-25-2013, 11:37 AM

Hello-
This is my first post on this forum! I am excited to learn more about VBA programming.

I have been looking for a VBA solution for a project I am currently working on. I found a few on this forum that i thought might work, but was unsuccessful at implementing them.

I have a master workbook that is being used for time tracking. It consists of (5) sheets named "Home","TaskData","LookupLists","RawData",& "Dashboard". The "Home" sheet has a userform where the end user enters data and clicks "submit". This data is inserted into the "TaskData" sheet. The information is then extracted from "TaskData" by formulas and is placed into "RawData", where I have formulas that separate the data out by user, task, and month. From here, the info is placed on "Dashboard" where I have created interactive charts that allow for more filtering.

What I would like to do is give a separate Workbook to each end user. This workbook would have a "Home" & "TaskData" sheet, so they can enter data anytime they want (to avoid having one workbook where 11 people are constantly bumping into each other). These workbooks (including the master) would all be stored in the same folder on a shared drive. Then the manager can have the "Master" workbook, with the (5) sheets listed above, that would have an "Update" button that would extract all new data from the "TaskData" sheet from all of the individual workbooks.

Any help is appreciated. Please let me know if more info is needed. Thank You!!

**ragavan.sridar1** · 01-25-2013, 11:44 AM

Did you tried to use the Data connection option?

Check the below given link.

http://office.microsoft.com/en-us/ex...010167227.aspx

**garfield0304** · 01-25-2013, 01:42 PM

Thanks for your rapid response! I tried this and it didn't seem to behave as i would like. I would like it to just add anything new since the last update and just append it to the bottom of "TaskData" on the Master Workbook.

**nabilbil** · 01-25-2013, 03:27 PM

Hi all, this is my first post in the forum and it has to be a request :-) I am trying to collect data from multiple workbooks into a master workbook based on defined criteria ; the first column in the master workbook contains criteria with different values in the other workbooks. the macro should populate the second column with the matching values from the first workbook, then move to the next column and populaate with the next workbook and .....
Can anyone help with this please?