This content has been marked as final. Show 2 replies
I have a qvw with 3 sheets
my Sheet1 is the filters (the filter is a simple table with a list of colors.
and sheet 2 - 3 are the data(sheet2 - sheet3)
What I want is to create a macro "poropably" on the sheets (2&3) properties and propably on (ONActivateSheet)
to apply a filter on the table that exists on Sheet1 (filters)
Example. when I select to see Sheet2 then in Sheet1 in tableA the system should pick the color "green" from the list of colors inside the table data....
anybody know how can I write this Macro?