+ Reply to Thread
Results 1 to 5 of 5

Copy row and insert X times

  1. #1
    Registered User
    Join Date
    03-18-2020
    Location
    Lithuania
    MS-Off Ver
    WPS
    Posts
    3

    Copy row and insert X times

    Good day, newbie here and thanks for the add, if this is anything like the VWT4 forum then i should be able to get my code working as good as my van :D

    Thanks for being here and i was hoping to get help with the below:
    outline:
    * on row 1, which will be hidden, i have a range of cells forming a template in A1:U1
    * further down i will have a number of rows in a table which already have a copy of the same cell information
    * one row down from the last row with the copied in information in the table i will have a blank row in the table and would like to place a button which when clicked will:
    * prompt user for a number
    * copy cells A1:U1
    * insert rows above the line where the button is with the template cells in place
    * keep inserting until the user entered number is reached

    hopefully someone can decipher my requirement and provide some code for me i have been searching all morning and trying different snippets of code together to get this working but keep getting errors.

    Thank you very much all !
    Tonino

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Copy row and insert X times

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

  3. #3
    Registered User
    Join Date
    03-18-2020
    Location
    Lithuania
    MS-Off Ver
    WPS
    Posts
    3

    Re: Copy row and insert X times

    Good day Pepe,
    you are absolutely right... i did miss that in my exited haste
    I will scroll down to manage attachments via the advanced tab...
    Chose file and seen it was attached then clicked close window... i dont see it here but will submit reply to see if it goes on
    Cheers for the pointer
    good day
    Tonino
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    03-18-2020
    Location
    Lithuania
    MS-Off Ver
    WPS
    Posts
    3

    Re: Copy row and insert X times

    well... banged my head and got it to work as follows:

    Please Login or Register  to view this content.
    Last edited by Pepe Le Mokko; 03-18-2020 at 06:30 AM. Reason: Code tags

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Copy row and insert X times

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    I did it for you this time. Please read forum rules. Thanks

+ 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 insert row multiple times to end of sheet
    By davidsd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2018, 09:19 PM
  2. [SOLVED] Copy and insert column x times
    By rpinxt in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-09-2017, 07:54 AM
  3. [SOLVED] Adapt copy and insert VBA code to ask how many times your would like it to copy and insert
    By Jamidd1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-10-2016, 04:59 PM
  4. [SOLVED] Copy a row and Insert that row 6 times below it
    By dustinshaw in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-28-2016, 02:32 AM
  5. Insert row when x value is found and copy x times
    By cossie2k in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-15-2014, 03:29 AM
  6. Copy then paste/insert X number of times
    By Steve6386 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-04-2010, 04:53 PM
  7. Macro to copy text certain # of times and insert new row each time
    By markdill in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-07-2007, 01:30 PM

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