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.
Bookmarks