Yes, explaining it is harder:-
last used cell in a column in one worksheet = worksheet called BOND cell B4

Different worksheet, in the cell you want the result
=sum('BOND!B4) press enter

This works for any cell not just the last used cell.

"Bundy" wrote:

I would like to be able to transfer the value from the LAST used cell in a
column in one worksheet into a cell on a different worksheet..is this
possible?
Thanks