+ Reply to Thread
Results 1 to 6 of 6

vba to split the cell value after comma as new rows with first rows value.

  1. 04-18-2016, 01:18 PM #1
    johnlara
    johnlara is offline
    Forum Contributor
    Join Date
    04-30-2013
    Location
    washington
    MS-Off Ver
    Excel 2019
    Posts
    168

    vba to split the cell value after comma as new rows with first rows value.

    Dear experts

    I have some range of data in column H:H account contains every 5 digit ID with comma i want split 5 digit after comma as new row along with paste down first cell value.

    for e.g 12510,12511, i want individual row of 12510 & 12511

    find the attachment.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-18-2016, 01:41 PM #2
    nilem
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: vba to split the cell value after comma as new rows with first rows value.

    Hi Johnlara,
    try this
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 04-18-2016, 01:50 PM #3
    Arkadi
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: vba to split the cell value after comma as new rows with first rows value.

    Another option:

    Please Login or Register  to view this content.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.
    Reply With QuoteRegister To Reply
  4. 04-18-2016, 01:55 PM #4
    stnkynts
    stnkynts is offline
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: vba to split the cell value after comma as new rows with first rows value.

    Yet another:

    Please Login or Register  to view this content.
    If you are happy with my response please click the * in the lower left of my post.
    Reply With QuoteRegister To Reply
  5. 04-18-2016, 01:58 PM #5
    GeneralDisarray
    GeneralDisarray is offline
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: vba to split the cell value after comma as new rows with first rows value.

    Try this code.

    This will add to the table on top (not make the table on bottom).

    Please Login or Register  to view this content.
    I had to change the last multiple account entry (you had a comma out of place).

    12686,12690,12705,12800,12810,12820,12830,12840,12865,12875,12885,12895,12915,12925,13000,13001,13002,
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.
    Reply With QuoteRegister To Reply
  6. 04-20-2016, 12:24 PM #6
    johnlara
    johnlara is offline
    Forum Contributor
    Join Date
    04-30-2013
    Location
    washington
    MS-Off Ver
    Excel 2019
    Posts
    168

    Re: vba to split the cell value after comma as new rows with first rows value.

    Thanks Experts wonder which code has to pick!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Split comma separated entries to new rows
    By dandi10 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-02-2020, 07:59 PM
  2. Count Comma Delimited values in Cell, Convert to rows, Repeat Remaining info next to Rows
    By avpowar in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-04-2016, 08:23 AM
  3. [ask] split text with comma to new rows
    By qiyusi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-26-2015, 09:27 PM
  4. [SOLVED] VBA: To Split comma separated entries to new rows
    By Cytokine in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-19-2014, 08:58 PM
  5. Macro to split Cells delimter comma to multiple Rows.
    By pavan5183 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-17-2013, 10:24 AM
  6. Macro to split a single cell data into rows and copying other cells as it is in rows
    By Pankaj Sonawane in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-25-2010, 07:09 PM
  7. Split comma seperated column in to new rows
    By singy33 in forum Excel General
    Replies: 1
    Last Post: 08-06-2009, 12:35 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1