Macro to copy data from one workbook to another and consolidate the data

[Thinker8]

Hi All,

I Need to write a macro for the following example.

Workbook 1 is the source sheet.

It has data as below

Basically I want to group by Column "Name" , Column "Task" and Column "Week" and also want to sum the total of hours. In this case, the result on the workbook 2 (destination sheet) would be as below

Hope this make sense.

Can anyone help me write an Excel macro for this please?

[Thinker8]

Hi ,

All the forum guru's please help me to write the code for the above scenario.

Thanks in advance.