VBA CODE: consolidation of excel sheets
 

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

VBA CODE: consolidation of excel sheets
 

Hi Questionmark,

Ron de Bruin has an extensive range of sample code at:

http://www.rondebruin.nl/tips.htm

See, for example:

http://www.rondebruin.nl/copy2.htm

and

http://www.rondebruin.nl/copy3.htm


---
Regards,
Norman



"questionmark"
wrote in message
news:questionmark.2aihu0_1152169203.4742@excelforu m-nospam.com...

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

VBA CODE: consolidation of excel sheets
 

Dear Norman,
Thank you for your immediate answer. The link sent by you looks ver
interesting and seems to be helpful. Let me check this! Kind regards
Q'mar

--
questionmar
-----------------------------------------------------------------------
questionmark's Profile: http://www.excelforum.com/member.php...fo&userid=3609
View this thread: http://www.excelforum.com/showthread.php?threadid=55876

VBA CODE: consolidation of excel sheets
 

Dear Norman,
Thank you for your immediate answer. The link sent by you looks ver
interesting and seems to be helpful. Let me check this! Kind regards
Q'mar

--
questionmar
-----------------------------------------------------------------------
questionmark's Profile: http://www.excelforum.com/member.php...fo&userid=3609
View this thread: http://www.excelforum.com/showthread.php?threadid=55876