View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NZuser NZuser is offline
external usenet poster
 
Posts: 13
Default Help with worksheet event

Hello,
I have a worksheet that has the following information:
Cell A: Name/Cell B:Amount/Cell C:Name/Cell D:Total
Jack $2 Jack
Bob $5 Bob
Jack $7 Mary etc
Mary $10
Each time an amount is allocated to Jack I would like the amount to go into
the total cell (Cell D)for him, and add it up, or even into another
worksheet, is this possible?
Kind regards
:-)