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.xl...
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.