Hi,

is it possible to create a filter which is cabable of masking the selected elements in more than one sheet? What I would like to do is create several tables on single sheets in the excel file, say table1 on sheet1 and table2 on sheet2 and in addition some kind of filter key table to select certain elements in the tables 1 and 2.

Example:

Table 1 contains informations to different companies.
Table 2 contains informations to different products.

The key table could contain informations about whether a company or a product can be found in certain countries. Now when apply a filter to the key table, displaying only the companies or products that can be found in germany for example, then the tables 1 and 2 should be automtically show only the informations to these companies...got what I mean?

How do I do that?

regards

Benjamin