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

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

I have just inserted a column(can be hide),rest is totally formulated

Hi wfm007,
Thanks for the suggestion. The requirement is to generate Sheet2 in a given format from Sheet1. Even if first 3 columns of Sheet2 are generated then we can use VLOOKUP as you suggested. I am actually looking for macro which can generate Sheet2.

Thanks

Manish

Hi ,
Can someone help me out?

-Manish