+ Reply to Thread
Results 1 to 8 of 8

Code to split

  1. 10-15-2016, 01:38 PM #1
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Code to split

    Hello:

    Please refer to attached file.
    I have data as shown in row 2 and i need to split up shown in row 4
    Let me know if you have any questions.
    Thanks.
    Riz
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-15-2016, 02:02 PM #2
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Code to split

    Could be done with a formula
    Enter in cell A4
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Enter in B4 and copy across
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    Reply With QuoteRegister To Reply
  3. 10-15-2016, 02:10 PM #3
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Code to split

    Hello Allkey:

    I really need VB Code this time.
    Thanks
    Riz
    Reply With QuoteRegister To Reply
  4. 10-15-2016, 02:11 PM #4
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,025

    Re: Code to split

    Oh Blast !! I've just noticed that you want VBA....

    here's a formula, if it's any use to you. Copy across:

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  5. 10-15-2016, 03:07 PM #5
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Code to split

    @ Glenn Kennedy,

    If it is going to be VBA, it should look like this:

    Please Login or Register  to view this content.
    Regards.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Reply With QuoteRegister To Reply
  6. 10-15-2016, 03:45 PM #6
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,025

    Re: Code to split

    Winon, what I know about VBA could be written on the head of a pin...

    in BOLD CAPITALS...
    Reply With QuoteRegister To Reply
  7. 10-15-2016, 04:01 PM #7
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Code to split

    Hi Winon and Rest of the group:


    This will work for me.

    Thanks a lot.

    Riz
    Reply With QuoteRegister To Reply
  8. 10-16-2016, 12:16 PM #8
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Code to split

    @ Glenn Kennedy,

    ...what I know about VBA could be written on the head of a pin...in BOLD CAPITALS...
    The same would apply to me regarding your Excellent Formula Skills!LOL. You are so funny, and enjoy your sense of humor!

    All I have done was to "translate" your Formula into VBA, and I am certain that rizmomin would have been clever enough ending up tweaking the Code as below,

    Please Login or Register  to view this content.
    Quite simple really.

    @Riz,

    Thank you for your feedback, and the Rep. Points. You are always welcome!

    Kind Regards, you guys.

    W.
    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] VB Code to split data
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-27-2016, 05:28 PM
  2. need vba code to split rows to closed wb shets depends company code met with sht name
    By julielara in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2016, 12:44 PM
  3. Need Macro code to split data split in 7 sheets based on variable rows in column A
    By Alija_21 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-31-2015, 08:03 AM
  4. [SOLVED] How to Split VBA code in New lines
    By naveenmarapaka in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-08-2014, 02:19 AM
  5. [SOLVED] VB Code to split data
    By Oszie in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-27-2013, 08:37 AM
  6. how to convert excel split code to word split code
    By gsrikanth in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2012, 07:56 AM
  7. Split code in more than one page ?
    By SpookiePower in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-16-2006, 06:25 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1