So I have researched a bit and haven’t found what I’m looking for.
I have 3 data sheets that contain employee metrics. Week 1, Week2, Week3.
Each data sheet has the same configuration but the data in each category is based on the week.
The employees are listed in rows with the data listed in the columns.
There are about 15 employees per sheet and each sheet contains the same employees.
I also have a blank template that I want be filled out for each employee. The template contains columns for each week and rows for each metric.
The only method I have come up with is to copy the template 15+ times and manual assign each cell to the corresponding data sheet and cell.
Is there a more effective way of achieving this? Maybe even macro that would create and new sheet and input the data for each employee?
I have 3 data sheets that contain employee metrics. Week 1, Week2, Week3.
Each data sheet has the same configuration but the data in each category is based on the week.
The employees are listed in rows with the data listed in the columns.
There are about 15 employees per sheet and each sheet contains the same employees.
I also have a blank template that I want be filled out for each employee. The template contains columns for each week and rows for each metric.
The only method I have come up with is to copy the template 15+ times and manual assign each cell to the corresponding data sheet and cell.
Is there a more effective way of achieving this? Maybe even macro that would create and new sheet and input the data for each employee?
