Excel macro help needed

Excel macro help needed

im having excel columen key value (scrNo and taskName TeamMember and hours)
scrNo taskName Hours TeamMembers (groupedby)
6533 project 10.5 santosh 6533 project 10 santosh 1423 team work 23 rajesh
2343 work order 10.4 ganesh 2354 testing 21.1 ganesh
TeamMembers are grouped by. and i want to create excel report based on
individual member effort hours like below and respective graph based on
scr no and hours. can any one help me to do in excel macro.![pleace check
the attach image.][1]
**EXCEL REPORT**
GANESH
ScrNo Hours
2343 10.5
2354 21.5
Total 32
Santosh... xx xxx Rajesh.... like above