I need to know how to return the value of a named cell in a different workbook.
For example, in file1.xls is a cell (P69) that has been assigned the name 'profit'.
Within that workbook I can use 'sum(profit)' to return the value of the cell named 'profit'.
That's fine, but I need to collate a large number of these in an overview workbook.
I can link to the absolute value by using '=[file1.xls]Sheet1!$P$69' but the cell I need the value for may change location. This is why I'd like to reference the name, as opposed to the cell location.
I've tried '=[file1.xls]sheet1!(profit)' and other variations, but don't seem to be able to get the syntax right.
Can anyone suggest the correct way to write this?
For example, in file1.xls is a cell (P69) that has been assigned the name 'profit'.
Within that workbook I can use 'sum(profit)' to return the value of the cell named 'profit'.
That's fine, but I need to collate a large number of these in an overview workbook.
I can link to the absolute value by using '=[file1.xls]Sheet1!$P$69' but the cell I need the value for may change location. This is why I'd like to reference the name, as opposed to the cell location.
I've tried '=[file1.xls]sheet1!(profit)' and other variations, but don't seem to be able to get the syntax right.
Can anyone suggest the correct way to write this?
