Hi Everyone,
This topic has been raised in other forums, but not here that I find.
Moreover, I can't find a definitive solution.
Here's the situation:
I have table filled with formulas. I use an Autofilter at the top of one column to filter out data that cannot be charted (zeros, nulls, negatives, etc..).
The table is highly dynamic. A small change in any input dramatically changes the data across the table.
Here's the problem:
My charts rely on the Autofilter to filter out data that cannot be charted. However, I often forget to hit the "reapply filters" button when the table data changes. This results in wildly inaccurate charts.
What I'd like:
Some way to ensure that the Autofilter automatically refreshes whenever the data in its column changes. This will probably require VBA --and I have essentially zero VBA skills.
What I've found:
I've found some VBA code from the very last post in an Ozgrid thread ( http://tinyurl.com/n288pg ). I tried to cut and paste the code into this post, but it pasted as an indecipherable hunk of condensed text.
Anyway, the guy who supplied the code is ecstatic that it will refresh an Autofilter whenever the column data changes.
What I did:
I accessed the VBA code for my data sheet, and copied the Ozgrid VBA code into something called "ThisWorksheet" (just below the words "Option Explicit"). Then I amended the code to identify the column whose filter I want to automatically refresh (specifically I changed "A3:A50" to "BA5:BA270").
What happened:
Nothing. I see no difference in behavior. The Autofilter does not refresh when the data in the BA column changes.
What now:
Since I prefer Excel Forum over OzGrid, I'm asking for help here first!
Ideas, anyone?
Cheers,
Jay
Bookmarks