How to have a total in sheet1 automatically plug in sheet2
 

I have a Total in Sheet1 and I want that total to always plug/udated in the
Second tab of the worksheet? help

How to have a total in sheet1 automatically plug in sheet2
 

If the total is on Sheet1 A10 then on sheet 2 where you want the total type
=Sheet1!A10
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"T" wrote:

I have a Total in Sheet1 and I want that total to always plug/udated in the
Second tab of the worksheet? help

How to have a total in sheet1 automatically plug in sheet2
 

"T" wrote:

I have a Total in Sheet1 and I want that total to always plug/udated in the
Second tab of the worksheet? help

T

If the formula total in sheet1 in in cell B2, in sheet2 type =Sheet1!b2.

If the range is dynamic in sheet 1 then leave plenty of room to expand the
data and in sheet2 type =Sum(sheet1!a2:a10000)

regards
Peter