I have a list of staff with related data associated with them. This data takes up 8 rows for each staff member. I like the way it is, so changing it is not an issue.
If I need more rows for new members of staff I use a blank template row and to a cut and paste job.
I want to know if it is possible to automate this. Unlike MS-Access, auto generating blank records are not often talked about.

Because the systems at work are Excel, and spreadsheets are not relational I have create rows that look like they have tables nested in them and need to cut and past to create row for staff.