I am fairly new to excel and have a delima. I have two worksheets. The
first worksheet has names and numbers, the second has names and numbers as
well. The data changes in worksheet 2 from week to week. I want to input
data in worksheet 2 and have worksheet 1 look at that data and append to what
is already has. If there are duplicates, I want it to sum the data. Can you
help...Here is what I have
Worksheet 1 (This is the worksheet with the combined data)
Name Points

Worksheet 2 (This data is to be combined with worksheet 1 and duplicates
need to be sum'd making 1 (running) total.

Example Worksheet 1 Worksheet 2
Name Points Name Points
Dan 20 Bob 20
Bob 14 Dan 8
David 14

I want it to look like this

Worksheet 1
Name Points
Bob 34
Dan 28
David 14

Can anyone help...