so I don’t know where to begin but basically I have a speadsheet with a table that we use for attendance. Every time we have a new person to add to the attendance we have to manually create 52 rows (1 for each week). I want to create a script that lets me input the persons information and then automatically creates the 52 rows with the persons information. The table also has 13 columns and we need to enter their name (column A), Location (Column B) and Department (Column K), I would like for those columns to be pre filled as well when we run the script and input in the values.

I tried recording the Macros for this but I’m not sure how to get it to update the values for the newly added rows.