Move cell data to another worksheet cell automatically.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Alan said:
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.
Click to expand...
 
This was very helpful to me many thanks !!

Ragdyer said:
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.
Click to expand...
 
Back
Top