Dynamic filter criteria

Hi all, good day!

Please Login or Register  to view this content.

Refering to the codes above, the number of criteria1 might change depending on my data.
Currently, I reserved up to 12 slots and manually adjust criteria1:=Array(rngTL_1.....) as necessary.
In my workbook, I do have a cell that indicates how many filters that is needed based on value calculated from my raw data ie if it's 7 then i have 7 criterias, if 4 then i have 4 criterias... so on and so forth...

it's there a way like rngTL_x where x is the number of filter needed, so that my users would not need to edit the code everytime the data is updated.

Thank you very much!

bump!

any assistance is very much appreciated.