MATCH perhaps

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JAH" wrote in message
ps.com...
Hello.

I have created a spreadsheet that lists the "current" balances of all
our mortgages. By using seperate worksheets containing each mortgages
amortization schedule, I would like to pull the "current" balance of
each mortgage onto the summary sheet. Is there any way to do this?

Example:

Todays date is July 24, 2007. The summary sheet would display the
cell containing the balance of the mortgage after the July 1, 2007
payment. This amount would be on the seperate amortization worksheet
for that loan.

Thanks in advance for any help.

JH