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.