The best way is to give the cell in the otherworkbook a name. Do this by
selecting the cell and then typing the name into the Name Box. The name box
is that area that will be displaying the address of the cell you've selected.
Click in the Name Box and give it a name such as myLastCell and end the
entry by pressing the [Enter] key - that's important.

Then in the other workbook, you can link to it as =Book1!myLastCell
and Excel will keep up with it no matter where it gets shoved around to.
For more information check out Excel Help on
Define named cell references or ranges
and
Name a cell or a range of cells


"zhj23" wrote:

Since the address of the last cell keeps changing as data are entered, how
can I link to this last cell from another workbook?

Thanks.

zhj23