If there is only one row per date and the dates are in order. you could use
lookup

=lookup(datevalue("1/20/07"),'worksheet1'a1:a10000,'worksheet1'c1:c10000 )
or

=lookup(today(),'worksheet1'a1:a10000,'worksheet1' c1:c10000)


where column a contains the date and column contains the balance you want.

"Dale" wrote:

I have a workbook with several sheets, one for each client. Each sheet shows
"Client Name", "Transaction Date", "Transaction Amount", "Balance". Now, I
wish to create a sheet with a "Summary" showing the "Client Name", "Balance"
for each sheet, and the "Summary" is based on "Today's Date".

How can I pick up the last balance of each sheet?