Home |
Search |
Today's Posts |
#1
|
|||
|
|||
is this possible?
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 |
#2
|
|||
|
|||
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 "Patrick" wrote in message ... 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 |
#3
|
|||
|
|||
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. "Patrick" wrote: 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 |
#4
|
|||
|
|||
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 -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- Patrick wrote in message ... 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 |
#5
|
|||
|
|||
This worked great!
Thanks. "Phil K" wrote in message ... 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. "Patrick" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|