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....
You can do it by using ACTIONS. It´s quite intuitive, and you can access them through Document, Sheet and some objects like Buttons and Text Box Properties.
.png "fernandotoledo"){kind=avatar}
