when adding row in linked workbooks, data in receiver loses a row

[Janice Lee]

I have two workbooks linked, and if I add a row to the data source, the cell
that the receiving worksheet holds, looses that new row and everything
shifts. I want the receiving worksheet to stay the same when I add a row to
the data source. I tried using the $ but it did not work.

 

[Héctor Miguel]

hi, Janice !

I have two workbooks linked, and if I add a row to the data source
the cell that the receiving worksheet holds, looses that new row and everything shifts.
I want the receiving worksheet to stay the same when I add a row to the data source.
I tried using the $ but it did not work.

instead of using a "direct" reference to "the cell", use index(<column>,<row_number>)
of some form with indirect(... assuming the two workbooks will be open -?-

hth,
hector.