increment number if criteria is matched

parts number parts sold
t1 0
t2 0
t3 0
t4 0
t5 0

everytime the macro button is pressed and a part number is chosen from the other sheet, it should look for the matching part number and increase the parts sold by one. how can i do that???

thanks

Something like:

Please Login or Register  to view this content.

based on your data being in A2 to B6