Forum Discussion
Get the column of a cell via it's reference in another sheet
I have an excel file AAA with names to refer to some cells.
Ex: TransactionNo refer to cell B1 when I'm into the file AAA.
What I want to do is to be able to use TransactionNo instead of [AAA.xlsm]AAA!B1 in the excel file BBB so if I insert/delete column in the file AAA, the value of TransactionNo will stay good.
Is there a way to use [AAA.xlsm]AAA!TransactionNo in my formulas when I'm in the BBB file?
While AAA.xlsm is open, the formula can be
=[AAA.xlsm]!TransactionNo
No need to specify the worksheet unless you defined TransactionNo explicitly as a worksheet-level name.
Then close AAA.xlsm. Excel will automatically add its full path to the formula.
Finally, save the workbook with the formula.
I have to mention the sheet because I have many sheets in my file AAA. Also, I have TransactionNo define in 2 differents sheets in the same file.In my file BBB, I took ='[AAA.xlsm]AAA'!$B1 and changed it by ='[AAA.xlsm]AAA'!TransactionNo and the result is #NAME?
Can you post a screenshot of the Name Manager dialog of the AAA.xlsm workbook?
