Prev: Finding the lowest cost for a product from a list
Next: If 3 If's, then sum
From: cmeyer on 16 Apr 2010 11:08
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?
 | 
Pages: 1
Prev: Finding the lowest cost for a product from a list
Next: If 3 If's, then sum