Move cell data to another worksheet cell automatically.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan - 09 Oct 2005 19:30 GMT

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 to this Message

Ragdyer - 09 Oct 2005 19:43 GMT

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.

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> 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 to this Message

Paula - 06 Apr 2008 20:05 GMT

This was very helpful to me many thanks !!

> Click in C4 and enter an equal sign,
> =
[quoted text clipped - 11 lines]
> called
> > Score in block C4. Both worksheets are in the same file.

Reply to this Message

Alan - 09 Oct 2005 23:11 GMT

Reply to this Message