Try Pivot Table€¦

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"David Beahan" wrote:

A table lists all products with sales for a period. I wish to filter that
list to only show the products that have a sales value. i.e. not products
with no sales. Easy with a filter but... I want the resultant table (the
filtered one) to update when a change is made in the primary table. I don't
want to have to complete the data in the primary table and then filter the
data to another location. Can this be done?