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?