SOLVED

Advanced Filter Automatically Updating

%3CLINGO-SUB%20id%3D%22lingo-sub-2341494%22%20slang%3D%22en-US%22%3EAdvanced%20Filter%20Automatically%20Updating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2341494%22%20slang%3D%22en-US%22%3E%3CP%3ELooking%20for%20assistance%20with%20trying%20to%20get%20advanced%20filter%20to%20automatically%20update%20when%20I%20add%20new%20information.%20I%20have%20tried%20changing%20VBA%20code%20(I'm%20not%20great%20at%20understanding%20this%20feature)%2C%20but%20I%20think%20what%20I%20need%20it%20to%20do%2C%20won't%20let%20it%20work.%20I%20have%20a%20main%20data%20tab%2C%20that%20needs%20to%20filter%20out%20to%20multiple%20sheets%20based%20on%20multiple%20criteria.%20I%20can%20do%20it%20using%20the%20advanced%20filter%20copy%20function%2C%20but%20it%20won't%20update%20automatically%2C%20which%20is%20annoying%20as%20I%20change%20the%20data%20monthly%20and%20it%20becomes%20very%20time%20consuming.%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2341494%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2342689%22%20slang%3D%22en-US%22%3ERe%3A%20Advanced%20Filter%20Automatically%20Updating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2342689%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1049971%22%20target%3D%22_blank%22%3E%40wbridgew%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWithout%20seeing%20your%20actual%20workbook%2C%20let%20me%20suggest%20that%20there%20is%20a%20new%20FILTER%20function%20that%20is%20very%20powerful.%20You%20may%20not%20need%20a%20macro.%20Here's%20a%20YouTube%20video%20that%20gives%20a%20solid%20introduction%20to%20that%20new%20function--which%20would%20require%20that%20you%20have%20the%20newest%20version%20of%20Excel.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20this%20seems%20to%20miss%20the%20mark%2C%20I%20would%20invite%20you%20to%20post%20a%20copy%20of%20your%20actual%20workbook%20or%20a%20mockup%20of%20it%2C%20so%20that%20we%20can%20get%20a%20more%20complete%20picture%20of%20your%20situation.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Looking for assistance with trying to get advanced filter to automatically update when I add new information. I have tried changing VBA code (I'm not great at understanding this feature), but I think what I need it to do, won't let it work. I have a main data tab, that needs to filter out to multiple sheets based on multiple criteria. I can do it using the advanced filter copy function, but it won't update automatically, which is annoying as I change the data monthly and it becomes very time consuming.  

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@wbridgew 

 

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.

Learn everything about our brand-new Dynamic Arrays and how you can use them to build advanced spreadsheets. Arrays (CSE) have long been present in Excel, bu...

@mathetes thank you very much, that did help!!!