hi all,

i have Sheet1, Column A with list of name
And Sheet2, column C with more than 1000 name list

Now i want to filter the Sheet2 , column c with the specific name listed in Column A of Sheet 1.

The list of name in Column A could differ, so i dont have fixed range.

can someone help me with startup example code