Time Sheet Calculation

Hi,

Please help me, how to implement the macro for Time sheet calculation, Please find the attachment, they are different name and different task with actual effort, so need to do macro, for Calculate the Effort and copy the name and Task into another tab.
See the Distribution tab, I given example.

i have lot of data with me, so manually calculating its taking more time, please help me.

Thanks