+ Reply to Thread
Results 1 to 2 of 2

How can I copy lots of lines and then paste them times 4

Hybrid View

  1. #1
    Registered User
    Join Date
    01-24-2015
    Location
    Venezuela
    MS-Off Ver
    2013
    Posts
    24

    How can I copy lots of lines and then paste them times 4

    This might be complicated to understand, but let's say I copy this from an excel document:

    90 75 85 115 90 55 510
    90 95 105 165 110 45 610
    45 95 50 40 50 75 355
    60 85 69 65 79 80 438
    90 110 80 100 80 95 555
    120 120 120 120 120 120 720
    55 112 45 74 45 70 401
    75 140 65 112 65 110 567


    is there anyway I could paste it or somehow get the values the exact same order they are placed, but every line multiplies four times somehow automatically, like this:

    90 75 85 115 90 55 510
    90 75 85 115 90 55 510
    90 75 85 115 90 55 510
    90 75 85 115 90 55 510
    90 95 105 165 110 45 610
    90 95 105 165 110 45 610
    90 95 105 165 110 45 610
    90 95 105 165 110 45 610
    45 95 50 40 50 75 355
    45 95 50 40 50 75 355
    45 95 50 40 50 75 355
    45 95 50 40 50 75 355

    As you can see, these 12 lines represents the 3 set of numbers from the first "table" (column and rows that I just posted above)

    I hope you can help me to find a solution, thank you.

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: How can I copy lots of lines and then paste them times 4

    This should do what you want.
    The values are in column A starting in row 2.
    The number of repeats for the values is in B2.

    Formula: copy to clipboard
    =IF(ROW()+1>COUNTA($A$2:$A$100)*4,"",INDEX($A$2:$A$100,ROUNDUP(ROWS($C$1:C1)/$B$2,0)))
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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] ws.Paste method fails after lots of copy-paste of shapes
    By bagullo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-15-2015, 03:00 AM
  2. copy and paste in one-go instead of performing 20 times copy & paste?
    By cyli2423 in forum PowerPoint Formatting & General
    Replies: 1
    Last Post: 08-24-2012, 06:06 AM
  3. VBA Inter-arrival Times, LOTS OF DATA, $ for help!
    By ath1337 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2010, 02:44 PM
  4. copy lines a specified number of times
    By Kim_J in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-28-2008, 12:00 AM
  5. I need to merge lots of info, w/o copy paste?
    By JWS Wholesale in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-18-2005, 02:13 PM

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