Search duplicates values based on certain criteria and then align the day to day data

[manishgupta_g]

Hello,
Sheet1 contains some day to day data . I am looking for macro which takes data from Sheet1 and put it in Sheet2 in a particular format.

Sheet2: P1, P2... refers to projects , A1,A2...refers to activities related to a particular project, Week starting date is starting day of a week, and Mon, Tue etc refers to Monday, Tuesday etc.

What the macro should do is to fill the Sheet2 in the prescribed format ans if there are common Project, Activity and week starting date then put them in one row. eg the below data

Projects Activity No of Hours Week No Date week starting date

P1 A1 8 6 4-Feb-13 4-Feb-13
P1 A1 8 6 5-Feb-13 4-Feb-13
P5 A3 8 6 6-Feb-13 4-Feb-13
P1 A1 8 6 8-Feb-13 4-Feb-13[/COLOR]

should be displayed as

Project Name Activity Name Week Starting date Mon Tue Wed Thu Fri

P1 A1 04.02.2013 8 8 8
P5 A3 04.02.2013 8


Can someone help me out ?

Thanks

-Manish