I have a bank statement on a worksheet and want to show the current balance
in another workbook.

I can copy a link for the current balance to the other workbook but do not
know how to update it when the bank statement is updated (i.e. in the next
row down).

Example:

Bank statement
Date Debit Credit Balance
15/5 0.00 100.00 100.00
16/5 50.00 - 50.00

It is this last total (50.00) which I need to update on the second workbook.

Is this possible please?