+ Reply to Thread
Results 1 to 3 of 3

Need Macro to Distribute Values within a Cell to Multiple Lines

  1. #1
    Forum Contributor
    Join Date
    05-29-2009
    Location
    Chattanooga, TN
    MS-Off Ver
    2021
    Posts
    205

    Need Macro to Distribute Values within a Cell to Multiple Lines

    I hope this is possible.

    In my attached example sheet, there are 8 different styles (I highlighted each group of styles) based on the style number (column A)

    Column I shows all the sizes each style comes in separated by semicolons, but I don't want all the sizes to appear in the same cell. It should only be one size per cell/line.

    For each style, starting from the first (left most) size, make that size the only value in the cell. Then the next row, make the second size value the only value in the cell, etc., then repeat with the next style.

    Then do the same with the quantity column.

    Sheet1 is the original file. Sheet2 is how I ultimately want the data to look like after running the macro in sheet1

    Can anyone do this?

    Thanks!
    Attached Files Attached Files
    Last edited by Ocean Zhang; 12-13-2014 at 02:34 AM.

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Need Macro to Distribute Values within a Cell to Multiple Lines

    Hi Ocean Zhang,
    try this
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    05-29-2009
    Location
    Chattanooga, TN
    MS-Off Ver
    2021
    Posts
    205

    Re: Need Macro to Distribute Values within a Cell to Multiple Lines

    that was great. thanks!

+ 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. [SOLVED] Cell Values In The Header with Multiple Lines
    By clemsoncooz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-13-2014, 09:26 AM
  2. How to chart multiple lines with inconsistent X values?
    By potejam in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-07-2013, 06:48 PM
  3. How to display values in multiple lines if multiple checkbox's are selected?
    By kjshep in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-10-2012, 10:10 AM
  4. [SOLVED] Macro to loop through cell values in a column and format multiple cell values
    By Roop in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2012, 05:39 PM
  5. Distribute a macro to multiple users
    By simjambra in forum Word Programming / VBA / Macros
    Replies: 6
    Last Post: 06-28-2010, 07:18 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