Results 1 to 9 of 9

Macro to split data into multiple cells

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-02-2015
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    2007
    Posts
    272

    Macro to split data into multiple cells

    Hi All,

    I need some help on a macro.
    I have multiple entries in column C which I would like to split it up and show in multiple cells based on Column A& Column B. For example as below

    Original
    Column A Column B Column C
    A 13.05.07 1,2,4,5
    B 15.08.09 9,8,7,6


    Output
    Column A Column B Column C
    A 13.05.07 1
    A 13.05.07 2
    A 13.05.07 4
    A 13.05.07 5

    Any idea anyone able to help me on this? Have attached the sample in tab Sample and how it should be in tab Output.
    Hope someone is able to help me out. :-)

    Kind Regards,
    Mark.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. MACRO to split new data into multiple tabs but not overwrite existing data
    By amo899115 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-11-2016, 01:42 PM
  2. [SOLVED] Macro attempting to split cells containing multiple co-ordinates into appropriate columns
    By Ethanrholt in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-06-2014, 10:56 AM
  3. Macro to split 1 row of data into multiple
    By ks04 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-15-2013, 03:27 AM
  4. [SOLVED] Macro to split cell data across multiple cells based on format-
    By Biased Historian in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-30-2013, 12:57 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. [SOLVED] How do you split a cell that contains multiple data to the cells beside it?
    By kjy1989 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2013, 08:37 AM
  7. Split cells long text with Max 40 character to multiple row using Macro
    By chee1012 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-31-2012, 10:10 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