Posted 21 April 2005 - 01:35 PM
You can link one cell in one spreadsheat to another in different spreadsheet; set up a summary spreadsheet, then link the cells from the others to the cells on the summary, and do the mathematical manipulations and/or graphs there.
The formula for summary cell would be =Sum ('spr1'! b3, "spr2"!b3), and so on, where spr1 is the name of a spreadsheet and b3 is the cell in it.
Whereof one cannot speak, thereof one should be silent.