Copy multiple rows, prompt user after which row to insert them

Attached the sample file, which is a meeting agenda.

User case: Accounting's topic is currently listed on rows 14-17. Admin topic is listed on rows 2-5 etc.
If the Accounting person needs to insert more topics to the agenda there are no empty rows after the row 17, as the Sales topics starts from there.
How to make the template work so that:
- topics can easily be added in between
- the total time calculation (now at D30) is kept updated. ( no idea if it can even be done)

I was thinking if I would make the rows 2-5 as template, which would be added with one click where the user wants them. Perhaps a prompt box asking "after which row number would you like to insert a new topic?" Or is there more simple solution?


I would like to make it easy for the users to insert the needed rows to the template, with just one click - if possible. Is it possible?
I know how to insert VBA, but I can not create the code (yet!).
Thank for any support you can provide.

Maybe something like this ?

Please Login or Register  to view this content.

I am not sure that I understand correctly of what you want though.
I'm guessing that what you want is something like this :

IF any person from any department want to add data
THEN :
- ask the user to type what department he/she is from
- insert 4 rows above that any_department inputted by the user.

These four rows will contain :
1a. column B row X = a number
1b. column C row X = the name of the department inputted by the user
2. column C row X+1 = "Time in mins" text
3. column C row X+2 = "Purpose" text
4. column C row X+3 = "Leader" text

The code will update the number consecutively in column B,
and the code also update the formula in the cell next to the right of a cell contain text "TOTAL TIME"

So after the macro runs,
the user just fill the blank cell corresponding to the row on point-1b, point-2, point-3 and point-4.

2021-09-02_17-00-40.gif