Hi Everyone, Yes... Me again...

Is there anyway for excel to refresh the filter every time you select a given worksheet.

I have a worksheet that gets it's info fed from an other worksheet and it only inserts the rows when data is required... hence I end up with several empty rows... I inserted a column that's can be use to filter it (rows containing values of "0" in column BC should be displayed)

But if you enter other data on the feed document it inserts the rows but since the filter doesn't refresh it doesn't show you the updated lines with out reselecting "0" in the BC filter.

This document is going to people with out any excel training so I don't want to have to included instructions on how to refresh the filter.

Thank