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.......

LastRow = .Cells.Find("*", .Cells(.Rows.Count, .Columns.Count), SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
.Range("A1:T" & LastRow).AutoFilter Field:=1, Criteria1:=Array("ITEM1", "ITEM2", "ITEM3", "ITEM4", "ETC"), Operator:=xlFilterValues
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,