Add multiple criteria to auto filter one by one via loop from a range / array

Hi All,

I have a sheet where there are multiple comma separated values in a single cell. First of all I'm looking for a simple code to isolate the separate parts into a range / array.

But that's the easy part (I'm sure I can find something on that online). However, once I have this range / array then I wish to loop through its values and add them as filter criteria.

So for example, I have the following cell value: "Type 1, Type 2, Type 3"

Then I want to filter the type column on these three values and exclude all other values.

Does anyone know of an easy way to do this? Maybe even without the use of a range / array?

Thanks!

Thanks Olly! It works wonderfully!! I figured there would be an easier solution, I just never expect it to be THAT easy.