Well, for a noob I'd say you should do it this way:

Click on the cell where you want the total to carry over to. Press =.
Just an equal sign. Then go to the sheet and cell you want the total t
carry over from and click on it then hit enter.

If you do exactly that you'll be on your way.

If you're copying from Sheet1 Cell A11 to Sheet2 Cell C22 then th
result in Sheet2 Cell C22 will look like this:

=Sheet1!A11

Is that clear? - Piku

--
Message posted from http://www.ExcelForum.com