=D12
Now, cell A3 will be set equal to whatever is in D12, with whatever
formatting adjustments there may be.
Now here's my problem....
If I INSERT a cell ABOVE D12, pushing the contents of D12 down to cell
D13, Excel adjusts the formula in cell A3 to
=D13
Excel changes the formula in an attempt to help me out. Often enough,
this is a helpful thing. But sometimes it isn't!
What if I want cell A3 to be set equal to whatever is in the EXACT
cell D12, regardless of whether any cells have been inserted above
it? Is there a way to anchor the reference to EXACTLY a specific
cell?
Thanks in advance for any help you may have!
P.S.
=$D$12 isn't what I'm looking for. That anchors in a different way,
not the way I'm seeking.
--
Brett
http://www.100bestwebsites.org/
"The 100 finest sites on the Web, all in one place!"
Widely-watched non-profit ranking of top Internet sites
Tyro
"Berkeley Brett" <Roya...@gmail.com> wrote in message
news:ca303e61-7314-42d4...@s13g2000prd.googlegroups.com...
"Berkeley Brett" <Roya...@gmail.com> wrote in message
news:ca303e61-7314-42d4...@s13g2000prd.googlegroups.com...
--
Tim Zych
SF, CA
"Berkeley Brett" <Roya...@gmail.com> wrote in message
news:ca303e61-7314-42d4...@s13g2000prd.googlegroups.com...
"Berkeley Brett"
<Roya...@gmail.com>
wrote in message
Tim and Jim nailed it! That's exactly what I was looking for!
=INDIRECT("D12")
does the trick!
Much thanks to all!