vba to filter only from the provided list

[prabhuduraraj09]

Hi all,

help to achieve the below,

I have Emp name Sack, mussori, cheek , tracy etc., in first sheet.

what i want is in sheet2, i have given the list of name
Tracy & cheek.

so i want code to filter Tracy and copy row to sheet3.
and again filter cheek and copy row to sheet3 below the tracy data.

I dont want to copy tracy and cheek data rows together.
i want to do it one by one.

And list of name which i will give in sheet2 ...may be any number of rows....
may be 60 or 70 names.

i want a code to apply filter and pick first name of sheet 2 and copy that data to sheet3
and to go on untill all the names listed in sheet2 is picked and data in sheet1 is copied and pasted in sheet3.

expecting some help on this......

attached example file

[alansidman]

Try this:

Please Login or Register  to view this content.

Note: In your sample file Creek is spelled two different ways. One is capitalized and the other is all lower case. I put the Option Compare Text into the code to assure that these would be treated as equal. If that is not what you wanted, then you should remove the Option Compare Text. In this situation, you would not copy over the values for Creek as you have specified creek as the criteria. VBA is very particular about this.