Linking different spreadsheets

N

NoviceIan

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
 
F

FSt1

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
 
Top