On Apr 14, 6:08*pm, "tkraju via OfficeKB.com" <u16627@uwe wrote:
Every day new values are added to the end of database sheet.
Col A *-- Col B *---Col C
john-----03/29/09--$45
mary----03/30/09---$205
mary *--- 04/01/09- $250
john * ----04/04/09 - $ 100
Bill * *----04/04/09-- $ 25
mary-----04/05/09---$50
mary *----04/06/09--$100
john -----04/10/09---$ 35

like this new records are added everytime.
*in Col D1,If i enter Apr-09 output will be like this
Col D
Apr-09
mary ----$400
john------$135
Bill-------$25
*Code from any body for this highly appreciated.

--
Message posted viahttp://www.officekb.com

tkraju,

I think I follow what you are trying to do. Have you tried using a
pivot table? You can set up the pivot table range as a named range
(i.e. in Excel 2003: Insert | Name | Define; in Excel 2007: Formulas |
Define Name), and then simply change the "Refers To" when your data
set expands to include all of the newly added cells. Of course, you
can design the pivot table however you like, but you can try the date
as the Page Field, the names as the Row Field, and the dollar value as
the Data Item.

Best,

Matthew Herbert