+ Reply to Thread
Results 1 to 6 of 6

Repeat Rows 12 times

  1. #1
    Registered User
    Join Date
    07-26-2013
    Location
    Minneapolis, USA
    MS-Off Ver
    Excel 365
    Posts
    8

    Repeat Rows 12 times

    Hello,

    I'm hoping someone can help me create a macro that goes through all rows in my data and repeats them 12 times. I've found similar macros but none with 2 columns that I can see.

    I've attached a spreadsheet to better illustrate my data and my desired outcome. There is no consistency in the data, sometimes a department will have 1 account, sometimes 5 accounts. Need it repeated 12 times regardless.

    Thank you in advance.
    Attached Files Attached Files
    Last edited by dg3; 03-12-2021 at 05:50 PM.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,089

    Re: Repeat Rows 12 times

    How about
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-26-2013
    Location
    Minneapolis, USA
    MS-Off Ver
    Excel 365
    Posts
    8

    Re: Repeat Rows 12 times

    Thank you! This works perfect. If I wanted to change the number to 8, what numbers would I change?

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,089

    Re: Repeat Rows 12 times

    For 8 you would use
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    07-26-2013
    Location
    Minneapolis, USA
    MS-Off Ver
    Excel 365
    Posts
    8

    Re: Repeat Rows 12 times

    I should have known. Thank you so so much. Saved me so much time.

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,089

    Re: Repeat Rows 12 times

    You're welcome & thanks for the feedback.

+ 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] Repeat columns multiple times as rows
    By AF_Z in forum Excel General
    Replies: 11
    Last Post: 08-01-2019, 12:58 PM
  2. [SOLVED] Repeat value from cell: X times with interval of Y rows
    By ISMI in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-24-2017, 12:49 PM
  3. [SOLVED] Repeat formula X times - once X times has been achieved then Y - repeat X again
    By jonnym28 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 11-25-2015, 11:53 AM
  4. Macro to repeat rows a certain amount of times (loop)
    By jadore in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2014, 10:46 PM
  5. [SOLVED] Repeat form X times, where X is the number of rows containing data in a separate sheet.
    By BB1972 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-07-2013, 05:05 PM
  6. Need macro help with transposing columns to rows and repeat a row value multiple times
    By InnovativeAJ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2012, 11:53 AM
  7. Replies: 17
    Last Post: 04-05-2009, 07:27 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