meeting agenda, using various filters

Here's another alternative - the filtering is macro-free and doesn't use any of your buttons, just the drop downs in B3:B5. Take a look at the attachment or put the formula below (entered with Ctrl + Shift + Enter instead of Enter) in D2, then fill right and fill down. I've set it to work on up to 400 entries in Sheet1, but you can expand the range if necessary.

=IFERROR(IF($B$5="ALL",INDEX(Sheet1!$B$3:$G$400,SMALL(IF((MONTH(Sheet1!$E$3:$E$400)>=MONTH($B$3))*(MONTH(Sheet1!$E$3:$E$400)<=MONTH($B$4))*(YEAR(Sheet1!$E$3:$E$400)>2000),ROW(Sheet1!$E$3:$E$400)-2),ROW(1:1)),COLUMN(A:A)),INDEX(Sheet1!$B$3:$G$400,SMALL(IF((Sheet1!$C$3:$C$400=$B$5)*(MONTH(Sheet1!$E$3:$E$400)>=MONTH($B$3))*(MONTH(Sheet1!$E$3:$E$400)<=MONTH($B$4))*(YEAR(Sheet1!$E$3:$E$400)>2000),ROW(Sheet1!$E$3:$E$400)-2),ROW(1:1)),COLUMN(A:A))),"")

Originally Posted by cantosh

Here's another alternative - the filtering is macro-free and doesn't use any of your buttons, just the drop downs in B3:B5. Take a look at the attachment or put the formula below (entered with Ctrl + Shift + Enter instead of Enter) in D2, then fill right and fill down. I've set it to work on up to 400 entries in Sheet1, but you can expand the range if necessary.

=IFERROR(IF($B$5="ALL",INDEX(Sheet1!$B$3:$G$400,SMALL(IF((MONTH(Sheet1!$E$3:$E$400)>=MONTH($B$3))*(MONTH(Sheet1!$E$3:$E$400)<=MONTH($B$4))*(YEAR(Sheet1!$E$3:$E$400)>2000),ROW(Sheet1!$E$3:$E$400)-2),ROW(1:1)),COLUMN(A:A)),INDEX(Sheet1!$B$3:$G$400,SMALL(IF((Sheet1!$C$3:$C$400=$B$5)*(MONTH(Sheet1!$E$3:$E$400)>=MONTH($B$3))*(MONTH(Sheet1!$E$3:$E$400)<=MONTH($B$4))*(YEAR(Sheet1!$E$3:$E$400)>2000),ROW(Sheet1!$E$3:$E$400)-2),ROW(1:1)),COLUMN(A:A))),"")

ooh, nice! thanks