I need some macro help.
I'm attaching 2 files so that my issue can be better understood.
What I'm trying to do with a macro is:
1. find the first employee in the list (employee's names will not always be the same) from Worksheet1.xlsx
2. find the first metric under this employee's name
3. copy the Total Time (Hours) from column E from Worksheet1.xlsx
4. find the metric and the employee's name in Worksheet2.xlsx and paste the data in the corresponding cell
5. find the second metric under this employee's name and then repeat steps 2 through 4 until all metrics are fulfilled for first employee
6. find the second employee in the list from Worksheet1.xlsx and repeat steps 2 through 5
7. repeat steps 2 through 5 until all employees in the list from Worksheet1.xlsx are complete
Note that the metrics under each employee may vary on Worksheet1.xlsx but the metrics on Worksheet2.xlsx will always be the same.
If anyone can help me with this, I would be tremendously grateful! Thanks!!