B
botto
Hi,
is it possible to create a filter which is cabable of masking th
selected elements in more than one sheet? What I would like to do i
create several tables on single sheets in the excel file, say table1 o
sheet1 and table2 on sheet2 and in addition some kind of filter ke
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
product can be found in certain countries. Now when apply a filter t
the key table, displaying only the companies or products that can b
found in germany for example, then the tables 1 and 2 should b
automtically show only the informations to these companies...got what
mean?
How do I do that?
regards
Benjami
is it possible to create a filter which is cabable of masking th
selected elements in more than one sheet? What I would like to do i
create several tables on single sheets in the excel file, say table1 o
sheet1 and table2 on sheet2 and in addition some kind of filter ke
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
product can be found in certain countries. Now when apply a filter t
the key table, displaying only the companies or products that can b
found in germany for example, then the tables 1 and 2 should b
automtically show only the informations to these companies...got what
mean?
How do I do that?
regards
Benjami