I have posted a workbook at http://cjoint.com/?etrwzrGdLu

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ashley0578" wrote
in message ...

I've attached the file I've been working on (names removed to protect
the innocent!).

What I expect to see on the recap sheet is the total amount of deals
unfunded for the month to date, which for this month would be April 1 -
April 19. Below that, I would see a sum of the total amount of money we
would expect to see from those customers by the end of their loan.

This would be the same for week to today (Sunday thru today).

All of this would be repeated for the funded deals and turndowns.


+-------------------------------------------------------------------+
|Filename: Deal Log example.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4658 |
+-------------------------------------------------------------------+

--
ashley0578
------------------------------------------------------------------------
ashley0578's Profile:
http://www.excelforum.com/member.php...o&userid=32757
View this thread: http://www.excelforum.com/showthread...hreadid=533059