I have filter applied to a column where the data is any positive whole number or 0. The data is populated dynamically using other tables which data is entered and resorted before populating the the table which I am trying to filter. E.g. I can have a series of 0s, 100, 150, 50, 200. After putting in new data elsewhere, I may have an additional 130, 160, etc.

I need to have a way of refreshing this table to show current data that is non-0. Thus have recorded a macro where it changes the filter to 'Select All' values, and then update the filter to omit '0' values. I have assigned this to a button to execute the macro to make it easier for my end users.

Unfortunately, the macro doesn't seem to get the 'Select All' part correct. New values introduced into the table since the macro's recording are also omitted along with the '0' values.

Should this be happening? Is there any way around this?