+ Reply to Thread
Results 1 to 4 of 4

Insert Extra Rows on Data Based on Values from Another Cell

  1. #1
    Forum Contributor
    Join Date
    05-29-2009
    Location
    Bloomington, Indiana
    MS-Off Ver
    Excel 2007
    Posts
    179

    Insert Extra Rows on Data Based on Values from Another Cell

    Attached is an example file.

    I need to create extra rows of duplicate data. The number of duplicate rows depends on the number of semi-colons in the 15th column (column O).

    Sheet 1 is the original working file. Sheet 2 is the result of how the executed macro for the first 2 lines of data. The first line in sheet 1 has 7 semi-colons, so there should be 7 rows of duplicate data created in sheet 2. The second line in sheet 1 has 6 semi-colons, so 6 duplicate lines, etc.

    Is this possible?

    thanks!
    Attached Files Attached Files
    Last edited by Ocean Zhang; 06-12-2014 at 07:20 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    668

    Re: Insert Extra Rows on Data Based on Values from Another Cell

    Try this
    Please Login or Register  to view this content.
    1. Include a sample workbook with an example of the result you want
    2. Use [CODE] and [FORMULA] wrappers for your VBA code or excel formulas
    3. If your question has been answered, mark the thread as SOLVED and click on the "Add Rep" star to thank whoever helped you.

  3. #3
    Forum Contributor
    Join Date
    05-29-2009
    Location
    Bloomington, Indiana
    MS-Off Ver
    Excel 2007
    Posts
    179

    Re: Insert Extra Rows on Data Based on Values from Another Cell

    k64, that was awesome. thanks!

  4. #4
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    668

    Re: Insert Extra Rows on Data Based on Values from Another Cell

    You are welcome! Thanks for the +Rep

+ 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] Insert Multiple rows based on the values in the cell
    By rlamba in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-13-2014, 09:27 AM
  2. [SOLVED] Insert number of rows with data to new sheets based on values in cells
    By keithtran12 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-28-2013, 11:57 AM
  3. [SOLVED] Insert Multiple Rows Based Off Number in Cell and Copy Data From Above New Rows
    By tstell1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-02-2012, 04:15 PM
  4. Insert Rows based on Cell Values
    By macrobatics in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 01-23-2011, 04:41 PM
  5. Insert number of rows based on cell values?
    By HBF in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-20-2009, 10:28 AM

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