I have a budget spreadsheet with a worksheet dealing with loans
between different accounts. Columns A to D contain the details
for one loan and columns E to H the details for a second loan.

Entries are made against each loan as they are added to or
payment is made with the result that they are now ending on
different rows. This could be D56 for one loan and H12 for the
second loan.

To make it easy to see where each loan is I have put a row at the
top of the sheet above the Freeze pane setting nominating the
amount owed.

What I need is a formula to automatically pick up the amount in
the last cell used in each of the columns D and H and write the
amounts in those cells in D2 and H2 respectively.

Any ideas on how this can be done?
--

Cheers . . . JC