I have columns of data in several worksheets, all in one workbook. The data in each column is dynamic, and any number from around 1000 to 100,000 cells in each column can be active at once. The remaining cells all show up as #VALUE!. Since this data is being sourced for a chart, I have filters set up to hide cells with #VALUE! in them. However, as the data changes, these filters are not automatically being applied. Thus the chart is not updating automatically with the data as it should.
I was using the following macro when I was only sourcing data from a single worksheet:
However when I started sourcing data from multiple sheets (all in the same workbook) it stopped working, now it only autofilters one sheet of data. I've tried copying it to every sheet in VBA but that doesn't seem to work. Can anyone identify what the problem is and how I can apply the proper code to my entire workbook?
Thanks!
Bookmarks