Dynamic Filtering...Need Help

Using Version Excel 2003

I have a report that retrieves different data based of data validation. In
each case there are rows that have no data and I want these hidden when the
user selects another data set based on their validation selection. To do
this I am using the auto filter function. The issue I am running into is
that each time a user selects a new report view they have to re-filter. Is
there a way, without using a macro, to have the filter re run based on the
users new selection withough having to re-filter?