My document has two sheets, 1 and 2, contains to AutoFilter tables with 10 columns (from A to J). I want to filter the tables like : in sheet 1 and 2, filter column J with values equal to 138, in sheet 2, filter column H with the values contained in the column H in sheet 1. The equality filter has to be applied first because I want to filter the column H with the values remaining after the equality filter.
In the AutoFilter standard filter, it is only possible to define up to 3 equalities. In my case, I need 13 of them (and potentially an arbitrary number). Note that I have column headers due to the AutoFilter.