Can you Filter using names from a generated list???

[Scott]

I have a macro that takes a list of peoples names from my data sheet, then
pastes them to a separate sheet and only leaves those names that appear 3
times or more. I would then like to use this list of names and go back to the
original data sheet and filter by each name one by one. For example, if John
Smith's name remains on my generated list, is there a way to plug his name in
to the filter for the original data set?? The list of names generated is in
column A of a sheet named "Employee Names" and the original data appears on a
sheet entitled "Data" with the names in column H.

 

[The Code Cage Team]

What is it you would want to do when filtering the names?


--
The Code Cage Team

Regards,
The Code Cage Team
http://www.thecodecage.com

 

[Scott]

When the list is filtered by that individuals name I am going to copy all the
data for that person and paste it on a new worksheet. Then I am going to the
next name and the next and doing the same for each.

 

[The Code Cage Team]

I have a workbook that does just that, join our forums and make a pos
regarding this and then pm me where i will attach the workbook in you
post, you will then be able to modify it to suite your needs

--
The Code Cage Tea

Regards,
The Code Cage Team
http://www.thecodecage.co