extra all rows from one workbook to another based on a list of criteria

Hello!

I'm a novice to VBA and having issues in copying rows in one sheet to another based on certain criteria.

I've got two Excel workbooks:
1 - CSAT: the first one contains 3 tabs, on the “Data1” worksheet it has ATM nearly 100000 rows and new rows are added each week. This file is containing the data of all employees.
2 - Stats: the second one is a reporting on only one team (5 to 10 agents), so just a portion of what’s in the “Data1” worksheet of the CSAT workbook. One sheet (“Agent_Stats”) with stats/graph/details about the team and its members and another sheet with the raw data (“Data_CSAT_FCR”).
The list of agents can vary depending of the team I want to have a look at

So I would like to have all rows from my list of agents copied from “Data1” and pasted on the workbook Stats (let’s call the worksheet “Data_CSAT_FCR”).

The macro has to clear first the worksheet “Data_CSAT_FCR” on the workbook Stats, I’m guessing that should work:

Please Login or Register  to view this content.

Then, the macro should look at the list of names specified in the workbook Stats, sheet “Agent_Stats” in cell J2 to J20 (some cells might be blank as all teams don’t have the same number of agents), found all lines in workbook CSAT sheet “Data1” that contain in column T the same agents and paste them in the Stats workbook on worksheet “Data_CSAT_FCR”.

Thank you so much for your help.