Filter column based on multiple criteria on another sheet

G'day

I need the following code modified so that it filters column D in Sheet 1 (from row 6), using all the entries listed in column A on Sheet 2 (from row 2).
Currently it only succeeds in filtering the first entry in Sheet 2 (row 2).

The amount of entries on Sheet 2 will vary (have tried .Range("A2:A") but does not work); and will at times also have entries which will not be on Sheet 1, so it needs to be able to ignore these and continue on to the next entry.

Is there a way to make the code pick up multiple criteria and to also ignore entries that cannot be matched please?

Please Login or Register  to view this content.

Sample code attached.

v needs to be 1D array

Please Login or Register  to view this content.

Wow, that was quick! and the solution so brilliantly simple. Thanks heaps jindon, you truly are a Guru legend. Very much appreciated.