Autofilter based on input from a range on a worksheet

Hi,

I have no idea if this is possible or not....

In a macro I am using autofilter on column A for an array of values, and for however many rows of data exist etc. Like this.......

Please Login or Register  to view this content.

I would like to read a list of values entered into column A of a worksheet, and then autofilter as above but for all of the values that existed in column A of a specified worksheet, whatever they were, and however many of them there were.

Lets say we have 'Worksheet1' which is blank, and 'Worksheet2' which contains data. In 'Worksheet1' we paste a list of unique values into column A, those same values also exist in column A of 'Worksheet2' (perhaps multiple times and among many others). I want a macro to read the contents of column A of 'Worksheet1', and then autofilter column A of 'Worksheet2' as above, for all of the values that were found in columns A of 'Worksheet1'.

Could anyone please help with example code on how this might be achieved?

Many thanks,