Go to the worksheet that you want to auto refresh filter when data changes. Right click the sheet tab, and select View Code from the context menu, in the popped out Microsoft Visual Basic for Applications window, please copy and paste the following code into the blank Module window, see screenshot: Note: In above code, Sheet 3 is the name of the sheet with auto-filter you use, please change it to your need.
Can someone imagine using Microsoft Excel without formulas? And hardly anything could compare to the frustration caused by Excel formulas stop working all of a sudden.
Then click to run the Flo and you will receive the information you were looking for.
There are demo videos on the website to help you get a feel for the service as a whole.
For example, when I filter all Apples from the data, now, I change one of the filtered data to BBBBBB, but the result will not be changed as well as following screenshot shown.There is a 14-day free trial that you can access to start off.Then you will have the ability to create a Flo where you can integrate your information from Smart Sheet and various other apps and use our wide array of functions to get the results you need.I have written a lot about Power Query M scripting language, and how to create custom functions with that.With recent updates of Power BI Desktop, creating custom functions made easier and easier every month.Code can be added to the Create a new settings file (.rd3x, .rd5x, .rdox) for distribution to end users that will include the VBA Extensibility code necessary to dynamically import this remotely located macro code.