copy a cell from sheet 1 to sheet 2
 

I need to copy the result in cell M75 - Sheet 1 to cell F8 in sheet 2
(same workbook)

Need the formula.

Thanks,

Bob M.

copy a cell from sheet 1 to sheet 2
 

hi
=Sheet1!M75
regards
FSt1

"robert morris" wrote:


I need to copy the result in cell M75 - Sheet 1 to cell F8 in sheet 2
(same workbook)

Need the formula.

Thanks,

Bob M.

copy a cell from sheet 1 to sheet 2
 

Thanks for the reply, one problem. When new numbers are entered into Sheet
1, they are updated on Sheet 1 but not on Sheet 2. Ideas?

Bob M.

"FSt1" wrote:

hi
=Sheet1!M75
regards
FSt1

"robert morris" wrote:


I need to copy the result in cell M75 - Sheet 1 to cell F8 in sheet 2
(same workbook)

Need the formula.

Thanks,

Bob M.

copy a cell from sheet 1 to sheet 2
 

On Sheet1, in M75, enter
100

On Sheet2, in F8, enter just an equal sign
=

Go back to Sheet1, and click in M75, and hit <Enter

You should automatically be transported back to Sheet2, and you should see
that 100 displayed in F8.

Did that work?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"robert morris" wrote in message
...
Thanks for the reply, one problem. When new numbers are entered into
Sheet
1, they are updated on Sheet 1 but not on Sheet 2. Ideas?

Bob M.

"FSt1" wrote:

hi
=Sheet1!M75
regards
FSt1

"robert morris" wrote:


I need to copy the result in cell M75 - Sheet 1 to cell F8 in sheet 2
(same workbook)

Need the formula.

Thanks,

Bob M.

copy a cell from sheet 1 to sheet 2
 

If you have entered the formula in Sheet2 F8 and value doesn't change when you
enter a new number in Sheet1 then I would check to make sure calculation mode is
in Automatic.

ToolsOptionsCalculation


Gord Dibben MS Excel MVP

On Thu, 18 Oct 2007 16:58:01 -0700, robert morris
wrote:

Thanks for the reply, one problem. When new numbers are entered into Sheet
1, they are updated on Sheet 1 but not on Sheet 2. Ideas?

Bob M.

"FSt1" wrote:

hi
=Sheet1!M75
regards
FSt1

"robert morris" wrote:


I need to copy the result in cell M75 - Sheet 1 to cell F8 in sheet 2
(same workbook)

Need the formula.

Thanks,

Bob M.

copy a cell from sheet 1 to sheet 2
 

This works! I still have some other numbers to enter. Will shout if I have
a problem.

Thanks,

Bob m.


"RagDyer" wrote:

On Sheet1, in M75, enter
100

On Sheet2, in F8, enter just an equal sign
=

Go back to Sheet1, and click in M75, and hit <Enter

You should automatically be transported back to Sheet2, and you should see
that 100 displayed in F8.

Did that work?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"robert morris" wrote in message
...
Thanks for the reply, one problem. When new numbers are entered into
Sheet
1, they are updated on Sheet 1 but not on Sheet 2. Ideas?

Bob M.

"FSt1" wrote:

hi
=Sheet1!M75
regards
FSt1

"robert morris" wrote:


I need to copy the result in cell M75 - Sheet 1 to cell F8 in sheet 2
(same workbook)

Need the formula.

Thanks,

Bob M.

copy a cell from sheet 1 to sheet 2
 

You're welcome, and appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"robert morris" wrote in message
...
This works! I still have some other numbers to enter. Will shout if I
have
a problem.

Thanks,

Bob m.


"RagDyer" wrote:

On Sheet1, in M75, enter
100

On Sheet2, in F8, enter just an equal sign
=

Go back to Sheet1, and click in M75, and hit <Enter

You should automatically be transported back to Sheet2, and you should
see
that 100 displayed in F8.

Did that work?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"robert morris" wrote in message
...
Thanks for the reply, one problem. When new numbers are entered into
Sheet
1, they are updated on Sheet 1 but not on Sheet 2. Ideas?

Bob M.

"FSt1" wrote:

hi
=Sheet1!M75
regards
FSt1

"robert morris" wrote:


I need to copy the result in cell M75 - Sheet 1 to cell F8 in
sheet 2
(same workbook)

Need the formula.

Thanks,

Bob M.