Investigate the use of "linking cells" through the Help section of Excel.

Also see "grouping worksheets" to learn how to link multiple sheets at one go.


Gord Dibben MS Excel MVP

On Mon, 26 Jun 2006 12:47:01 -0700, freckles
wrote:

i need to put my formulas into a seperate worksheet, i need to total multiple
cells and the answer to go to another worksheet.

Gord Dibben MS Excel MVP