Linking different spreadsheets
 

Hi all,

I have several seperate spreadsheets all in the same format and I was
wondering if it would be possible to create another to total up the contents
of the current lot. Is this possible?

It has to be a seperate spreadsheet to avoid unnecessary complication for
other staff.

Thanks Ian

This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/consol.zip
It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm

The "Bread-Roll" consolidation method - great for accountants. See how
simple it is to consolidate any combination of your organisation's accounts.
(No VBA used)


--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"NoviceIan" wrote in message
...
Hi all,

I have several seperate spreadsheets all in the same format and I was
wondering if it would be possible to create another to total up the
contents
of the current lot. Is this possible?

It has to be a seperate spreadsheet to avoid unnecessary complication for
other staff.

Thanks Ian

hi,
not entire sure what you have in mind but yes. it involves putting the file
path to the other file in the formula'
If the other file has totals already you might use somthing like this....

=('S:\PUBLIC\Ae-pc\WOM\FY03\[WorkOrderMonitoring Jan.xls]MPX'!$A$4)

this will bring the contents of a cell to your WB.
if no totals in the other file, this might work....

=SUM('S:\PUBLIC\Ae-pc\OM\FY03\[WorkOrderMonitoring Jan.xls]MPX'!$Z$4:$Z$500)

Careful. the last fomula wrapped.

Good luck

FSt1




"NoviceIan" wrote:

Hi all,

I have several seperate spreadsheets all in the same format and I was
wondering if it would be possible to create another to total up the contents
of the current lot. Is this possible?

It has to be a seperate spreadsheet to avoid unnecessary complication for
other staff.

Thanks Ian