Easier way to copy formula that are linked?
do you have a $ before the row number or column letter? if so, remove it.
"Martz" wrote:
I've been troubled with copying a formula and need to know if there is an
easier way to do it: I have two Excel spreadsheets "a" contains the majority
of the information while I need "b" is a tracking sheet based on some of the
cells in "a". I link cells in "b" to "a" with no problems and when I update
"a" the "b" cells update accordingly. On the "b" spreadsheet 10-12 cells (in
columns) are linked to the "a" spreadsheet - The Problem: when I copy lines
in "b" (because I run out of them) I have to change each column cell to
reflect the correct "a" link. Please help - if that's possible!
--
Michelle
|