As a very VBA-beginner the tasks I am confronted with are more
challanging than my progress ;-). So I urgently need your pleasant
help!

STARTING POINT:
-in a sub-folder (c:\company_xy\Business_Units\) i do have different
excel-files (each single file represents one business unit in a
company) including
-several sheets (each sheet represents one cost center)
-these sheets - regarding the format - all look the same,
-except: number of sheets per file (=number of cost centers) differs
-these files/sheets contain income statements as follows:
First Column (=y-axis): Description of Income/Expense position (e.g.:
interest revenues, staff costs,...).
first row (=x-axis): timeline[2004, 2005, 2006,...]

-(please see the attached example) -

QUESTION:
How can I merge the figures of each of these tables into one file (i.e.
company_income_statement.xls) in the superordinated folder
(c:\company_xy\company_income_statement.xls)? I.e. all cells in the
defined range (i.e. B2:D8) have to be totalised in the according
sheet.

Can somebody of you guys help me by providing me the according
VBA-code? Thank you in advance and best regards, Q’mark


+-------------------------------------------------------------------+
|Filename: Example_BU.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4986 |
+-------------------------------------------------------------------+

--
questionmark
------------------------------------------------------------------------
questionmark's Profile: http://www.excelforum.com/member.php...o&userid=36096
View this thread: http://www.excelforum.com/showthread...hreadid=558764