I have a formula on Sheet 1.

Can I move the cell that shows the total of the formula from sheet 1 to
sheet 2, so that any changes in the data, on sheet 1, would show up on Sheet
2 in the total box? Can't quite figure it out.

Thanks,

Patrick