Forum Discussion
Advanced Filter Automatically Updating
Without seeing your actual workbook, let me suggest that there is a new FILTER function that is very powerful. You may not need a macro. Here's a YouTube video that gives a solid introduction to that new function--which would require that you have the newest version of Excel.
https://www.youtube.com/watch?v=9I9DtFOVPIg
If this seems to miss the mark, I would invite you to post a copy of your actual workbook or a mockup of it, so that we can get a more complete picture of your situation.
Without seeing your actual workbook, let me suggest that there is a new FILTER function that is very powerful. You may not need a macro. Here's a YouTube video that gives a solid introduction to that new function--which would require that you have the newest version of Excel.
https://www.youtube.com/watch?v=9I9DtFOVPIg
If this seems to miss the mark, I would invite you to post a copy of your actual workbook or a mockup of it, so that we can get a more complete picture of your situation.
