Extract data like filter by formulas

I've put this formula in L4 of the Data sheet:

=IF(INDEX($C$4:$J$26,,MATCH(Result!$H$2,C$3:J$3,0))<>"",MAX(Data!L$3:L3)+1,"")

and copied it down (coloured blue). This identifies records in the chosen month which are not empty and gives each a unique sequential number.

Then in A4 of the Results sheet I have this formula:

=IF(COUNTIF(Data!$L$4:$L$26,ROWS($1:1)),INDEX(Data!A$4:A$26,MATCH(ROWS($1:1),Data!$L$4:$L$26,0)),"")

which brings the appropriate data across from column A of the Data sheet. As you submitted an .xls file, I have made this formula compatible with versions 2003 and earlier - I would normally use an IFERROR around the INDEX/MATCH. A similar formula is in B4:

=IF($A4<>"",INDEX(Data!B$4:B$26,MATCH(ROWS($1:1),Data!$L$4:$L$26,0)),"")

although this tests to see if A4 is empty before bringing the corresponding data from column B of the Data sheet. In C4 I have this formula:

=IF($A4<>"",INDEX(INDEX(Data!$C$4:$J$26,,MATCH($H$2,Data!C$3:J$3,0)),MATCH(ROWS($1:1),Data!$L$4:$L$26,0)),"")

which brings the data from the chosen month. These three formulae are then copied down to the bottom of your table

Just change the month using the drop-down in H2 to see the result change.

Hope this helps.

Pete

my best friend Yasser
look Please this file
My friend Yasser.xlsx