(Solved) – Using formula to operate the last sheet of an external workbook

  • by
(solved)-–-using-formula-to-operate-the-last-sheet-of-an-external-workbook

There are 2 workbooks as below:

A.xlsx and B.xlsx

Thinking about making a formula in the cell $A$1 of A.xlsx to refer to cell $A$1 of the last sheet of B.xlsx, just like the following.

='[B.xlsx]lastsheet'!A1

It can be done by giving the last sheet of B.xlsx a name called “lastsheet” but it is not flexible when a new sheet is regularly added.

Any solution apart from VBA?

Leave a Reply

Your email address will not be published. Required fields are marked *