Need help with VBA

Giganews Newsgroups
Subject: Need help with VBA
Posted by:  Need help with sumif
Date: Fri, 12 May 2006

I'm not sure If I could explain this easy but let me try

on sheet1 there are name list
on sheet2 there are list of names with their earning in $(Name could appear
more than once)
on sheet3 I want to find all cells that contains (David) in sheet2 & what
ever $
that's next to it add it when I click a command button

If this doesn't explain enough maybe I could attach the sample let me know
Thanks !!!!