Assume you have sheets called Sheet1, Sheet2, Sheet3, €¦


Say that the TOTAL you want is in Sheet3 in cell A30, and you want this to
appear in cell A10 on Sheet1.

In Sheet1, cell A10 press the equals sign (=), then with you mouse select
Sheet3 and position your cursor in A30 and hit enter.

Select Sheet1, in A10 you will find you have the value from Sheet3, A30.

The formula should look like =Sheet3!A30

Hope this helps.

Pank


"Jenney Zellner" wrote:

Please help. I am trying to create a formula that uses a total from a
different worksheet in a specific cell that is not the same as the original
worksheet that will contain the actual formula.