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.
|