Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Move cell data to another worksheet cell automatically.
I have a sum formula in block F3 of a worksheet called Furlong. It is his
total season bowling pinfall. I want the program to automatically transfer this total, each time it is updated, to his team record on a worksheet called Score in block C4. Both worksheets are in the same file. |
#2
|
|||
|
|||
Click in C4 and enter an equal sign,
= Then, navigate to the other sheet, and click in F3, And hit <Enter And you're done! You've let XL create a link for you between the two cells, where C4 will automatically display whatever value is in F3. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Alan" wrote in message ... I have a sum formula in block F3 of a worksheet called Furlong. It is his total season bowling pinfall. I want the program to automatically transfer this total, each time it is updated, to his team record on a worksheet called Score in block C4. Both worksheets are in the same file. |
#3
|
|||
|
|||
"Alan" wrote: I have a sum formula in block F3 of a worksheet called Furlong. It is his total season bowling pinfall. I want the program to automatically transfer this total, each time it is updated, to his team record on a worksheet called Score in block C4. Both worksheets are in the same file. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Move cell data to another worksheet cell automatically.
This was very helpful to me many thanks !!
"Ragdyer" wrote: Click in C4 and enter an equal sign, = Then, navigate to the other sheet, and click in F3, And hit <Enter And you're done! You've let XL create a link for you between the two cells, where C4 will automatically display whatever value is in F3. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Alan" wrote in message ... I have a sum formula in block F3 of a worksheet called Furlong. It is his total season bowling pinfall. I want the program to automatically transfer this total, each time it is updated, to his team record on a worksheet called Score in block C4. Both worksheets are in the same file. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I populate a cell with data from another worksheet, | Excel Discussion (Misc queries) | |||
how do I populate a cell with data from another worksheet, | Excel Discussion (Misc queries) | |||
Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
How do I move data from one cell and add to another? | Excel Worksheet Functions |