Multiple matching entries displayed as one record with cumulative totals

How do I show multiple entries for an ID number as one Row with the Day Hours (column B) being summed everytime that ID number is added to a list in a different Worksheet

EG

(COL A) COL B
ID HOURS
A15 5
A15 5
A15 5

On worksheet B I need this to display as

ID HOURS
A15 15

(if an ID code is entered for the first time it should be added to Column A but after that only the Hours should sum per entry)

Sorry difficult to explain - please see my example attached for hopefully more clarity.

Thanks

I'm not being given the attachment option for some reason?

Scroll down in the reply and/or edit, there is a button that says manage attachments.

Originally Posted by Dulanic

Scroll down in the reply and/or edit, there is a button that says manage attachments.

Hi - yes, normally thats what I do but for some reason the link isnt working??

I've got an error message in the bottom corner of the screen (Done, with errors on page)

Cheers I'll have a go.

I couldnt find LIST under DATA but I've created a Pivot - is this correct as I've done it?

Thanks very much - I will work on it and see how I get along.

No idea why it started working?