Automatically adding rows

Hi there guys!
First of all, very happy to find a forum like this, since i'm just starting to get into the "fancy" excel functionalities .

An here i am, asking for some help :D

I am currently trying to create a excel workbook, that counts hours worked by employees, that part is solved. Now the other thing is, i wanted to ask, whether it is possible to create a function in excel, that would create a set of rows and columns for each row in the other spreadsheet?

That should look something like this:

A manager has a spreadsheet that contains the info of the employees in the company:
Screenshot 2021-10-14 at 20.06.09.png

Then there could be a button or some kind of an indicator to proceed with the creation. and for each employee, rows and columns like these would be created in the next sheet:

Screenshot 2021-10-14 at 20.06.41.png

I hope my question is understandable, and mostly, solvable.

Thank you guys!

Assumptions:
1. The employee data in the worksheet named "Employee data" begins with cell A1.
2. The data to be copied is contained in the "Template sheet" from cell A1. The first row contains the dates in the I:O columns. The table to be copied is the range A2:R8 (the last row is blank).
3. Data is copied to a new sheet in the same workbook.

Please Login or Register  to view this content.

Artik

Hi, Artik!
Seems to be doing what i need, the problem is, that it only creates the template for the first employee.
Any ideas why is this happening?
Thanks!

It would be a good idea to include a workbook that shows the layout of the data in your worksheets.

Artik

Attaching the XLSM file:
It seems that now it is creeating the templates, but inserts the name only in the first one

Artik,
Thank you very very much!
Do you know by any chance if it is possible to create a "button" in excel, that would execute the macro?
Thanks!

It is possible, but not in this thread, as the issue differs significantly from the main problem.

Artik