Results 1 to 3 of 3

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

Threaded View

  1. #1
    Registered User
    Join Date
    02-17-2021
    Location
    Helsinki, Finland
    MS-Off Ver
    365
    Posts
    31

    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.
    Attached Files Attached Files
    Last edited by Tsinos; 09-01-2021 at 03:48 AM. Reason: Added file

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy and paste selective rows of data from a user prompt
    By kolokoy in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 03-09-2016, 03:51 PM
  2. Macro to Copy/Insert Copied cells based on user input # of rows/formatting rules
    By gaker10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2015, 11:42 AM
  3. [SOLVED] Copy and insert rows based on user input
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-27-2015, 10:34 AM
  4. [SOLVED] Prompt to insert user name in directory
    By jh51745 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-03-2013, 10:01 AM
  5. Macro to find-insert and Prompt user for Text Loop
    By excellentlearner in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-22-2012, 08:33 PM
  6. [SOLVED] user input into active excel macro- prompt - respond -insert-cont
    By Richard Duke in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2006, 10:50 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1