- Joined
- Oct 14, 2005
- Messages
- 1
- Reaction score
- 0
If in A1 (blank excel file) I have a link as result of a manual operation (writing =, going to price list excel file, select a cell and then press enter, then going back to the original blank excel file) as result I have '[price list.xls]book1''!$A$4, this formula is shown at the fx small window. The link formula bring the value 'banana'
A1
banana
fx = '[price list.xls]book1''!$A$4
B1
4
fx = row (C1)
C1
'[price list.xls]book1''!$A$4
fx= ??????? using A1
now I use and other cell B1 to calculate the row of '[price list.xls]book1''!$A$4, as follows: =row('[price list.xls]book1''!$A$4) giving me 4.
The problem is that every time I change the link in A1 I have to rewrite the formula in B1.
Is there a way to extract the link formula from A1 --> '[price list.xls]book1''!$A$4, put it in a cell C1l and used it as data variable, so in B1 I’ll have something like = row (variable)?, which variable content is '[price list.xls]book1''!$A$4, in this way does not matter how many time I change the link in A1, B1 always will show the value of the row of A1 contents.
Thankshttp://http://
A1
banana
fx = '[price list.xls]book1''!$A$4
B1
4
fx = row (C1)
C1
'[price list.xls]book1''!$A$4
fx= ??????? using A1
now I use and other cell B1 to calculate the row of '[price list.xls]book1''!$A$4, as follows: =row('[price list.xls]book1''!$A$4) giving me 4.
The problem is that every time I change the link in A1 I have to rewrite the formula in B1.
Is there a way to extract the link formula from A1 --> '[price list.xls]book1''!$A$4, put it in a cell C1l and used it as data variable, so in B1 I’ll have something like = row (variable)?, which variable content is '[price list.xls]book1''!$A$4, in this way does not matter how many time I change the link in A1, B1 always will show the value of the row of A1 contents.
Thankshttp://http://
Last edited: