Help on VBA array!

Hi,
I have two sheets "main" and "import" sheets.
Main sheet has all the program names and milestone start and end.
Import sheet has the raw data in this format Import 2.xlsx.

I need to take dates for some milestones with respect to the program name.
Steps my code does
1.First I am taking the entire import sheet as a array x.
2.Then I am taking the unique program names from array x taking the unique value into array z.
3.I need to get the best start(if approved is available means approved else planned) and best finish(same condition as best start)

But I am stuck after this.

Please Login or Register  to view this content.

I have already posted this in
http://www.ozgrid.com/forum/showthread.php?t=193942

If I should not post here means sorry.
But a solution will do great help for me
Thanks.