Formula for capturing the latest balance

[sayang]

Hi,

I have a file (I'm using MS Excel 2002) with 3 sheets (please refer to attachment).

In the SUMMARY sheet, I would like cell E11 to capture the latest balance in column G of the C4 WINDOW (Machine) sheet. In this case, cell E11 should capture 11,750

And in the SUMMARY sheet again, I would like cell E12 to capture the latest balance in column G of the C5 WINDOW (Self-Adhesive) sheet. In this case, cell E12 should capture 13,500

As the latest balance in column G will change whenever there is a new entry, I was unable to use the ='sheet'!cell formula

Any help is appreciated!

[protonLeah]

On sheet "C4 WINDOW (Machine)", cell L&, I entered the formula:

Please Login or Register  to view this content.

to get the address if the last balance in column G; Then on the SUMMARY sheet, cell E11, I entered the formula

Please Login or Register  to view this content.

[sayang]

hi protonLeah ,

superb! thank you very much!
thank you for solving the problem.

[DonkeyOte]

rather than using INDIRECT which is Volatile I would advise you use the standard approach for retrieving last numeric value in a range, namely LOOKUP with BIGNUM... eg:

E11: =LOOKUP(9.99999999999999E+307,'C4 WINDOW (Machine)'!$G$7:$G$27)

[sayang]

Another great answer! Works nicely. Thanks very much DonkeyOte !