+ Reply to Thread
Results 1 to 8 of 8

VBA to split respective multiline from 3 columns

  1. 06-04-2018, 09:03 AM #1
    chilli16
    chilli16 is offline
    Registered User
    Join Date
    12-02-2011
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    73

    VBA to split respective multiline from 3 columns

    Hi, i am with issue of referencing multiline content splitting wherein raw multline content of cell need to be split. i found one somewhat similar situation elsewhere which uses comma as delimiter the code like follow

    Please Login or Register  to view this content.
    my issue is this works on one column i am intereseted wherein multiline of first column of each three column is taken and rest content is duplicated. this process is repeated for each multiline. attached is the file which demonstrate raw data and VBA expected output. highlighted blue data is need to be gerenrated by VBA.

    regards
    monika
    Attached Files Attached Files
    Last edited by chilli16; 06-05-2018 at 04:52 AM.
    Reply With QuoteRegister To Reply
  2. 06-04-2018, 10:00 AM #2
    MickG
    MickG is offline
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: VBA to split respective multiline from 3 columns

    Try this for results on sheet "After VBA"
    Please Login or Register  to view this content.
    Regards Mick
    Reply With QuoteRegister To Reply
  3. 06-04-2018, 10:49 AM #3
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,190

    Re: VBA to split respective multiline from 3 columns

    My spin...Sheets("Raw data")

    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  4. 06-04-2018, 12:06 PM #4
    chilli16
    chilli16 is offline
    Registered User
    Join Date
    12-02-2011
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    73

    Re: VBA to split respective multiline from 3 columns

    thank you both codes works as expected Just a minor bug only few columns are duplicated. I have situation wherein column number changes can be 30 or sometime 10 can we make it dynamic all other column are duplicated. not limited to 5
    Reply With QuoteRegister To Reply
  5. 06-04-2018, 12:39 PM #5
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,190

    Re: VBA to split respective multiline from 3 columns

    VBA to split respective multiline from 3 columns
    Pls upload an accurate account of your requirement...
    Reply With QuoteRegister To Reply
  6. 06-05-2018, 01:00 AM #6
    chilli16
    chilli16 is offline
    Registered User
    Join Date
    12-02-2011
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    73

    Re: VBA to split respective multiline from 3 columns

    Quote Originally Posted by sintek View Post
    My spin..
    Thank you for code it works as expected I changed range :I to :ZZ to cover all columns.
    i have one issue if cell content we are splitting contains only one line code gives no output in 'Head 2A Head 3A Head 4A' means it only runs if multiline exist. is their way to make loop to solve it?
    Reply With QuoteRegister To Reply
  7. 06-05-2018, 02:05 AM #7
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,190

    Re: VBA to split respective multiline from 3 columns 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 07-30-2018, 11:14 AM #8
    chilli16
    chilli16 is offline
    Registered User
    Join Date
    12-02-2011
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    73

    Re: VBA to split respective multiline from 3 columns

    Thank you so much for help!!!
    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. [SOLVED] macro split specific data to respective columns but should not exceed 32 characters
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-01-2018, 02:24 PM
  2. Formula to split data to their respective columns
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-06-2018, 06:42 AM
  3. [SOLVED] vba split data in respective columns based on unique list sheet
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-29-2017, 02:40 PM
  4. [SOLVED] formula to split data in respective columns
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-06-2017, 02:21 PM
  5. [SOLVED] formula to split data to their respective columns
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-16-2016, 11:50 AM
  6. [SOLVED] TextBox multiline split
    By biznez in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 05-06-2016, 05:55 PM
  7. Need amacro to split values into respective customer
    By mk_santhosh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-19-2014, 10:34 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