Extend Formula
 

So, Sheet1 Cell B2 I have =Data!A2, basically wanting to copy the value

from cell A2 on data sheet to cell B2 on Sheet 1.

Previously, I would use fill handle to drag down and cell B3 would then

populate to =Data!A3, B4 = Data!A4 etc.. and their corresponding values



But tweaked something??? now the formula is still referencing the =
Data!A4, but the value appearing is the same as the first cell B2


Tried changing Tools\Options\Edit\Extend Datarange format and formulas,

no success...


Thanks,
D

Extend Formula
 

Check if your calculation is set to automatic.

<Tools <Options <Calculation tab,
And make sure "Automatic" *IS* checked.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
wrote in message
oups.com...
So, Sheet1 Cell B2 I have =Data!A2, basically wanting to copy the value

from cell A2 on data sheet to cell B2 on Sheet 1.

Previously, I would use fill handle to drag down and cell B3 would then

populate to =Data!A3, B4 = Data!A4 etc.. and their corresponding values



But tweaked something??? now the formula is still referencing the =
Data!A4, but the value appearing is the same as the first cell B2


Tried changing Tools\Options\Edit\Extend Datarange format and formulas,

no success...


Thanks,
D