Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Alan
 
Posts: n/a
Default 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   Report Post  
Ragdyer
 
Posts: n/a
Default

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   Report Post  
Alan
 
Posts: n/a
Default



"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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 138
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I populate a cell with data from another worksheet, deniseh Excel Discussion (Misc queries) 3 October 4th 05 07:00 PM
how do I populate a cell with data from another worksheet, deniseh Excel Discussion (Misc queries) 0 October 4th 05 02:34 PM
Conversion of Cell Contents into a Functional Worksheet name ? GMJT Excel Worksheet Functions 1 August 21st 05 04:59 PM
Printing data validation scenarios SJC Excel Worksheet Functions 14 July 24th 05 12:43 AM
How do I move data from one cell and add to another? wntw Excel Worksheet Functions 8 March 10th 05 02:28 AM


All times are GMT +1. The time now is 01:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"