Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
Problem with link cells between 2 spreadsheets | Excel Discussion (Misc queries) | |||
Linking between spreadsheets does not work unless I have both spr. | Excel Discussion (Misc queries) | |||
Compare two spreadsheets to find differences. | Excel Discussion (Misc queries) | |||
How do I get my actuarial spreadsheets to comply with SOx? | Excel Discussion (Misc queries) |