If sheetB and SheetA are in the same workbook, then your formula should adjust
ok.

If those two sheets are in two different workbooks, then the formulas will
adjust nicely if both workbooks are open.

If you can't open the other workbook and you only have a few (whatever that
means), you could name each cell (insert|name|define) and refer to those names
in your formulas.



37Drive wrote:

I have a link from a cell on Sheet B that refers to a cell on Sheet A. When I
add a row to Sheet A (and the cell gets 'bumped down'), my reference is off
by that row? What can I do to automatically update this? How do I apply some
type of relative reference so that no matter how many rows I add, the
references shuffle with the new row position?

--

Dave Peterson