Macro for consolidating files back into one workbook

[Drexl27]

Hi All,

In the attached spreadsheet, I have a macro that splits up the data based on category and creates 9 separate files within the same folder.

These files are then looked at and updated by other employees, and what I'm looking for is a macro that will then take the updated 9 files and consolidate them back into the original workbook on a new Sheet, in the same format that they are originally (but with updated numbers of course).

Let me know if you can help, or if you need any more information.

Thanks!general 2015 percentages.xlsm

[Doc.AElstein]

Hi Drexl27,
. Here is a basic solution. Probably not too efficient as it interacts a lot with the spreadsheet and there are some extra bits to make to a bit more understandable, etc..
.
. Try it out, let me know how you get on, and if necessary I / we can improve / change it.
.
. To make this code work i modified your code which saves the Group Files Thus:

Please Login or Register  to view this content.

... The modification gives a Range filled with the last made Group file names Thus:

Using Excel 2007

Row\Col	AL	AM	AN
1	Group
2	AP	Comm Acct080620152336
3		HR080620152336
4		Prop Acct080620152336
5		Office Services080620152336
6		Corp Acct080620152336
7		IT080620152336
8		Payroll080620152336
9		CFO080620152336
10		AP080620152336

gen.percents

.. This is needed for my following code to work.

Code:

Please Login or Register  to view this content.

...
. I have run the code a few times. It seems to work
Alan

[Drexl27]

This seems to be working really well! I'm going to tinker with it a big, although I'll probably have more time to do so on Monday. So if I find any bugs or issues that I think could be made better I'll report back here. Thanks!

[Doc.AElstein]

This seems to be working really well! I'm going to tinker with it a big, although I'll probably have more time to do so on Monday. So if I find any bugs or issues that I think could be made better I'll report back here. Thanks!

OK, thanks for the Feedback.