Creat a quick link to combine data

[mbotros1]

i downloaded a spreadsheet with multiple same names such as

Name Week ending Days off
John Smith 1/31 2
John Smith 2/7 1
John Smith 2/7 3
Peter Sun 1/31 1
Peter Sun 2/7 2
Andy Mann 3/14 3

if i wan to sum these up by name, what's the best way to do that?

Thanks,
Max

 

[mbotros1]

Does anyone have an idea how to link these 2 spreadsheet so that total the common factor/denominator in both spreadsheet is the employee name, but in source sheet there are multiple categories that need to be grouped and entered in the 2nd sheet.

Help please. Thanks

 

[PCL]

Cross post
"http://www.ozgrid.com/forum/showthread.php?t=187043&page=2"
Combine 2 sets of data