Absolute and Drag

[vmagal1]

I can't get the formula to drag over and change the last value when using an
absolute reference. I'm linking data from another worksheet and then
changing the cell in the formula bar to D$3 and it still treats it like its
all absolute. Help!

[Chip Pearson]

If you drag a cell, Excel doesn't change the reference,
regardless of whether the reference is relative or absolute.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"vmagal1" <vmagal1@discussions.microsoft.com> wrote in message
news:58BAD316-D73D-44E4-97A8-6D791310D0E4@microsoft.com...
>I can't get the formula to drag over and change the last value
>when using an
> absolute reference. I'm linking data from another worksheet
> and then
> changing the cell in the formula bar to D$3 and it still treats
> it like its
> all absolute. Help!