I am keeping a running log of mutual fund activity. Something like this:

Date Shares Price Daily Total Gain/Loss
6/1/2007 503.30 40.53 20,398.83 0.00
6/2/2007 503.30 40.59 0.06 20,429.03 30.20


I have several funds like this. I want to take the most recent balances and
summarize them on another sheet. So in other words, when i enter in a new
days worth of infomation, the formula on the other sheet will automatically
pick up the latest information. Something like this:

Fund A Shares Balance
Fund B Shares Balance

Any way to do this easily? Also, would there be an easy way to maybe drop in
a date and have it pick up the information for that date? I am trying to
create Quicken or Money in Excel because those 2 programs can be SOOOOO hard
to use for this stuff. Thanks.