+ Reply to Thread
Results 1 to 6 of 6

Looking for a macro to break out multiple numbers in one cell into separate rows

  1. #1
    Registered User
    Join Date
    05-26-2015
    Location
    Kansas City, MO
    MS-Off Ver
    MS Office 2010
    Posts
    3

    Lightbulb Looking for a macro to break out multiple numbers in one cell into separate rows

    Looking for a macro - any help is appreciated!

    Essentially, the excel file is in this format:

    Column 1 Column 2
    Cara 12, 13, 14

    And I need it in this format:

    Column 1 Column 2
    Cara 12
    Cara 13
    Cara 14

    Please see the attached excel file for further detail on what I need help with.

    Thanks for your help in advance!

    Excel Forum Macro Help.xlsx

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Looking for a macro to break out multiple numbers in one cell into separate rows

    This will put your data on sheet2

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    05-26-2015
    Location
    Kansas City, MO
    MS-Off Ver
    MS Office 2010
    Posts
    3

    Re: Looking for a macro to break out multiple numbers in one cell into separate rows

    Hi stnkynts,

    Thank you very much for sharing this. Given this is my first time ever creating/running a custom macro, I'm a little unsure if I understand the "Sub elbertta()" portion. Does this need to be included in the macro? Or should I substitute the elbertta statement for something else?

    Thank you!

  4. #4
    Registered User
    Join Date
    05-26-2015
    Location
    Kansas City, MO
    MS-Off Ver
    MS Office 2010
    Posts
    3

    Re: Looking for a macro to break out multiple numbers in one cell into separate rows

    Hi stnkynts,

    Thank you very much for sharing this. Given this is my first time ever creating/running a custom macro, I'm a little unsure if I understand the "Sub elbertta()" portion. Does this need to be included in the macro? Or should I substitute the elbertta statement for something else?

    Thank you!

  5. #5
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Looking for a macro to break out multiple numbers in one cell into separate rows

    The "Sub" is indicating that it is a subroutine as is a neccesary part. The "elbertta" after it is the name of the subroutine and is completely arbitrary in this situation. You will want to copy the entire code (sub included) and paste that into a module within the Visual Basic Editor.

  6. #6
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: Looking for a macro to break out multiple numbers in one cell into separate rows

    Here's another.. it should be reasonably fast on larger data sets as there is not much interaction with the sheet..

    Please Login or Register  to view this content.
    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)

Similar Threads

  1. Separate Cell Content into Multiple Rows
    By CSutton520 in forum Excel General
    Replies: 3
    Last Post: 09-12-2012, 12:29 PM
  2. Loop macro for multiple separate graphs from rows of a large data set
    By GlennToms in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2012, 02:12 PM
  3. Take Data from 1 cell and separate to multiple rows
    By sratkins in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-04-2011, 08:44 PM
  4. [SOLVED] Break cell into multiple lines by line break
    By Chia in forum Excel General
    Replies: 1
    Last Post: 08-20-2006, 01:40 AM
  5. [SOLVED] macro to copy multiple rows to separate worksheets
    By OrlaH in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-08-2006, 10:20 AM

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