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

  • by

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.


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 *