meeting agenda, using various filters

heya

i have a meeting agenda with 6 columns (where, who, when, comments etc). one column is the month (Jan, Feb), another column the place where the meeting takes place.

i need an overview sheet where i can filter (dropdown?) months (using also an option to show several months, pe. JAN - MAR) and at the same time the possibility to have an additional filter applied using the place of meeting. Once filtered (for example, JAN - APR, Germany), all entries for this filter should show up either directly, or using a macro.

the actual workbook with the meeting information is a working file and regularly updated. the meeting places (filter) are fixed.

i would need a as straight forward as possible solution and i have to say, i'm kind of lost at the moment - any idea is highly welcome

Are you able to post a small sample workbook (Use: Go Advanced --> Manage Attachments, then follow the prompts) so we can see what you're working with? Be sure to alter or remove any sensitive data.

i actually created it using a lot of IF/AND/OR's and a basic macro - not so familiar with proper filtering / pivots anymore.
however, i know there are much better / lean ways to solve, any idea welcome

attached the file with dummy entries.

CODE For Filter

Please Login or Register  to view this content.

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