So macro is pretty straight forward. One large list of data is in putted on to one tab. Macro is then ran. On the macro there are 20 hidden tabs. These 20 tabs are split between check results and check filter. Check filter shows what columns need to be filtered by what criteria, these columns can remain hidden always. check results is where I need the macro to paste the filtered data for a particular check, and afterwards to be unhidden. That's it, this is then repeated 9 more times.
I just want to make this as flexible as possible so I want to be able to add lots of filter criteria on certain checks so the macro will need to be able to filter based off any of the filters on the "table tab" and each header could be filtered several times so I need the macro to look at the "check filter tab" to see how many filters to apply and to which headers. I have added some examples to the sample spreadsheet I've done up but when its is in use there will be several more needed.
Any questions just ask,