Update link to another workbook w/o absolute ref

  • Thread starter Thread starter Andy at BLE
  • Start date Start date
A

Andy at BLE

I've linked
Workbook A, Sheet 1, A2
with
Workbook B, Sheet 1, C3.
The link formula resides in Workbook A.

The link treats the cell reference as absolute, so if I
resort rows, for example, in Workbook B so that the C3
moves to D4, the link still refers to C3.

Does anyone know how to write a link so that it will not
be absolute? Is that possible?

Thanks. Andy
 
Back
Top