I’m hitting a brick wall with a new sheet and wondering if anyone might have a suggestion.
In short, my problem is that Excel’s Auto Filter mode is not dynamically filtering my sheet.
When I select “Reapply” it works fine – but it does not work automatically when the filtered data changes.
I’ve tried many solutions, including various VBA code that is supposed to update the filter results.
However, that VBA code only seems to work if new data is entered manually and the Enter Key is pressed.
The data in my sheet is updated via WEBSERVICE calls to a 3rd party data vendor– so no manual data entry and no Enter Key depressions.
I would be very grateful for any suggestions.
Thanks in advance.
In short, my problem is that Excel’s Auto Filter mode is not dynamically filtering my sheet.
When I select “Reapply” it works fine – but it does not work automatically when the filtered data changes.
I’ve tried many solutions, including various VBA code that is supposed to update the filter results.
However, that VBA code only seems to work if new data is entered manually and the Enter Key is pressed.
The data in my sheet is updated via WEBSERVICE calls to a 3rd party data vendor– so no manual data entry and no Enter Key depressions.
I would be very grateful for any suggestions.
Thanks in advance.