T
tkraju via OfficeKB.com
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.
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.