+ Reply to Thread
Results 1 to 6 of 6

replicate a number of cells

  1. #1
    Registered User
    Join Date
    11-20-2011
    Location
    Switzerland
    MS-Off Ver
    Office 365
    Posts
    13

    replicate a number of cells

    hi all
    I have some cells in a column which I want to replicate across the spreadsheet: like copy N cells and paste starting from the next available cell in the same column,; I need to do that many times: meaning for example, 10 cells to fill about 13000 cells downward.
    how can I do that quickly?
    also, how can I record a macro in such a way that the cells are variable and not fixed?
    Last edited by alisam; 11-22-2011 at 12:15 PM.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,196

    Re: replicate a number of cells

    A little more clarification.

    Let's say cells A1:A10 are filled...what do you want to happen from there?

    Do you want those numbers filled down starting at A11 until x number of times are complete?
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    11-20-2011
    Location
    Switzerland
    MS-Off Ver
    Office 365
    Posts
    13

    Re: replicate a number of cells

    yes exactely: i want to replicate A1:A10 x times

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,196

    Re: replicate a number of cells

    Try this...

    Place your cursor in A1 and then hit the button...
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-20-2011
    Location
    Switzerland
    MS-Off Ver
    Office 365
    Posts
    13

    Re: replicate a number of cells

    it helped thanks: is there a possibility to make it more generic? as in instead of column A, any chosen column and being able to choose the times I want to replicate?

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,196

    Re: replicate a number of cells

    Try this variation. Just select the first cell in the column and then hit the button to enter the number of times to replicate.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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