W
wm
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?
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?
)