Absolute value changing in linked workbooks
That worked! Thank you!
"JE McGimpsey" wrote:
One way:
=INDEX([WorkbookA.xls]Sheet1!$A:$A,3)
Note that your leading + is superfluous in XL.
In article ,
Marnie wrote:
I want to link Row 3 in workbookA to Row 5 in workbookB. In WorkbookB cell
A5 I have:
=+[WorkbookA.xls]Sheet1!$A$3
The links are working except when I insert a row above Row 3 in WorkbookA.
It changes the absolute reference to $A$4. I want it to remain linked to row
3.
I would appreciate a suggestion.
|