Create new rows based on part of the value in a cell

**vjboaz** · 03-19-2014, 08:27 AM

I would like to create a new row based on the value contained within a cell - add that value to the last column.
Example
Test 1 1, 2, 3, 4, 5

The macro should create
Test 1 1
Test 1 2
Test 1 3
Test 1 4
Test 1 5

Thanks for your help!

VJB

**Kaper** · 03-19-2014, 09:02 AM

Pity you have not posted sample workbook. because a lot depends on data layout.
Let's assume that

Test 1 1, 2, 3, 4, 5

is a typical content of column A.

This code would separate it reqired way

Please Login or Register  to view this content.

**vjboaz** · 03-19-2014, 01:20 PM

Test 1 is in Column A
1,2,3,4 is in Column B

How would I adapt your code to make that work? I have attached a sample.

Thank you so much!!!

Test3.xlsx

**JOHN H. DAVIS** · 03-19-2014, 01:59 PM

FWIW:

Please Login or Register  to view this content.

**Kaper** · 03-19-2014, 02:24 PM

Version adopted to different (easier!) layout:

Please Login or Register  to view this content.

PS. Funny thing - I could offer exactly the same macro today on our national forum in thread: http://www.excelforum.pl/topics1/kol...415.htm#221703

Create new rows based on part of the value in a cell

LinkBack

Thread Tools

Rate This Thread

Display

Create new rows based on part of the value in a cell

Re: Create new rows based on part of the value in a cell

Re: Create new rows based on part of the value in a cell

Re: Create new rows based on part of the value in a cell

Re: Create new rows based on part of the value in a cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Create Multiple Rows based on Cell Value by way of VBA

[SOLVED] Splitting a Cell based on "/" and adding new Rows based on Part Number Logic

Hiding Rows based on PART of Cell Item

Create Multiple Rows based on Value in Cell

Create custom output based upon part of a cell's data

Bookmarks

Bookmarks

Posting Permissions