Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extend on an index formula I already have | Excel Worksheet Functions | |||
extend my formula with increments of 4 cells | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |