Excel help

How can I reference (link), from an Excel 2000 cell, the last used cell in a column.

For example, a spreadsheet has rows of entries of debits and credits. A new balance is calculated in the Balance column for each row. In another sheet I want to reference the most recent balance (last used cell in the Balance column).

How do I write the link?