Detail of each project

[mai07]

This file contains 2 sheet Main M and Detail D.
In Sheet Detail D, When I choose Code, month of Project, it will be shown the result.
By the way, tell me how to delete the Auxiliary column in Main sheet.

[ChemistB]

See the attached file. I replaced all your offset formulas with INDEX/MATCH formulas and created a unique identifier in your "Aux Column" column using
=C12&"_"&COUNTIF($C$12:C12,C12)

Then, in D!C9 for example
=IFERROR(INDEX(M!$F$12:$F$19,MATCH($AI$1&"_"&ROWS($A$1:A1),M!$B$12:$B$20,0)),"")
For your data, in D9 copied across and down
=IFERROR(INDEX(M!$H$12:$NH$19, MATCH($AI$1&"_"&ROWS($A$1:A1),M!$B$12:$B$19,0),MATCH($AJ$1,M!$H$10:$NI$10,0)+COLUMNS($A$1:A$1)-1),"")
Does that work for you?

[mai07]

Sorry, how to delete Protected viewed in your file ?

[ChemistB]

I didn't protect anything. What did you want to delete?