Ref in two worksheets

  • Thread starter Thread starter wm
  • Start date Start date
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?
 
This formula will return the *last* numeric value from the referenced range:

=LOOKUP(1E100,D:D)

If you want this to link to a different file then just include the path and
sheet name.
 
Back
Top