is this possible?

  • Thread starter Thread starter Patrick
  • Start date Start date
P

Patrick

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
 
Patrick, maybe something like, =SUM(Sheet1!A1:A10) ????
If not well will need more info.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
You can also use the copy paste special option. Copy the cell that has the
sum on Sheet 1 and the go to sheet 2 right click on the cell you want the
sum to show up, click on paste special and then click on paste link.
 
Maybe just try a cut and paste ?
Right-click on the cell with the formula in Sheet1 > choose Cut
Click on Sheet2's tab, then right-click on a target cell inside > Paste
 
This worked great!

Thanks.


Phil K said:
You can also use the copy paste special option. Copy the cell that has
the
sum on Sheet 1 and the go to sheet 2 right click on the cell you want the
sum to show up, click on paste special and then click on paste link.
Click to expand...
 
Back
Top