CONSOLIDATING MULTIPLE (CLOSED) FILES HELP!!!!!!!

ajmckenna

Board Regular
Joined
Oct 7, 2002
Messages
145
I want to create a macro, or a formula for the following :

Problem summary: trying to consolidated financials forecasts for ~15 separate programs (5 yrs out) into one financial statement summary for the company

each individual program has its unique projection model that is layed out in same format. I cannot just enter a formula to calculate a consolidated Jan 2002 sales for example:
+'c:ProgramsProgram1[Program1P&L.xls]2002P&L!'$B$5 + 'c:ProgramsProgram2[Program2P&L.xls]2002P&L!'$B$5 + etc....

Too many characters will be in formula.

Any ideas? Also if I was to add a 16th program how do I easily incorporate it?
If there is a helpful website link on this please advise.


Thanks all
 
Hi!

You'd probably get faster help if you posted this in the Excel questions forum.

This particular "questions" forum is for things about the board itself
 

Forum statistics

Threads
1,203,663
Messages
6,056,623
Members
444,878
Latest member
SoupLaura

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top