Tabulation of Project Plan Data in Excel

Hi

I am currently carrying out a large mandrolic activity in inputting data from one of our departments on a weekly basis, tabulating extensive data from dates provided in an Excel Project Plan for use in our weekly KPI tables.

The data is laid out as it is in sheet1, and I am trying to automate the plan to output to the table in sheet2.

I have tried a couple of Index array formualas to gather the necessary data, however, I cannot see anything to give me the output to then write in a macro by combining the Dates as slpit in x2 fields and outputing it by the plan phase.

Any help would be really appreciated.

AttachmentSize
Excel Tabulation Test.xlsx15.59 KB