Excel filter over multiple sheets
 

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


--
botto
------------------------------------------------------------------------
botto's Profile: http://www.excelforum.com/member.php...o&userid=36022
View this thread: http://www.excelforum.com/showthread...hreadid=558112