Hi All,
I have a report where I want to use a filter to filter out any line that has a cell that matches a list on a separate worksheet.
The list of items to be hidden changes constantly, so it needs to be visible on a control sheet and not buried within a macro.
I have this macro that works...