Macro for consolidating files back into one workbook

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

Originally Posted by 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!

OK, thanks for the Feedback.