+ Reply to Thread
Results 1 to 3 of 3

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

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

    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

  2. #2
    Valued Forum Contributor
    Join Date
    11-04-2018
    Location
    Denpasar
    MS-Off Ver
    Excel 2010
    Posts
    775

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

    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
    Last edited by karmapala; 09-02-2021 at 05:13 AM.

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

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

    Thank you so much for your input! You understood it absolute 100% correctly. And your code is working like a dream.
    This is so useful for me as the users of the file are "excel totally beginners" and even adding rows can be challenging for them.
    Thank you and be safe!

+ Reply to Thread

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