Create duplicate rows based on value in a column

**PGonzalez** · 02-06-2010, 04:18 PM

Hello, All. I need a VBA/macro very similar to several I have seen posted here. I have a worksheet with two columns and a few hundred lines. One has titles and the other integers indicating how many times the title needs to be copied to another worksheet or text file.

Existing Worksheet (Input)
TitleA 1
TitleB 6
TitleC 4
TitleD 3

Desired Output (Worksheet or Text File) [The entire row, including the integer could be copied as well, if it is easier.]
TitleA
TitleB
TitleB
TitleB
TitleB
TitleB
TitleB
TitleC
TitleC
TitleC
TitleC
TitleD
TitleD
TitleD

This should be simple, but I am a total newbie with Excel VBA/macros. A sample is attached. Any help will be greatly appreciated.

[Thanks to both for quick and clear replies.]

**JBeaucaire** · 02-06-2010, 04:43 PM

Like so:

Please Login or Register  to view this content.

This will create the listing for you on Sheet2. Make sure Sheet1 is a clean set of data and run the macro. It assumes the data starts at row2.

**Mallycat** · 02-06-2010, 04:46 PM

here you go

Please Login or Register  to view this content.

**BChiddy** · 04-24-2012, 11:28 AM

Perfect! Thanks Mally

**amyarms** · 12-04-2012, 04:54 PM

Do you have this on your website?

**siddha28** · 01-20-2014, 06:28 AM

Please help me am not able to run that file....

how and where multi column created .

please share how to use that file.......

Kindly do the needful.

**IamVBADumb** · 04-12-2014, 07:33 PM

How can you modify this code to copy an entire row a number of times specified in one column, such as the second column in this example? This code works great for copying the first column, but what if I need to copy many columns? Thanks!

**arlu1201** · 04-14-2014, 01:34 AM

IamVBADumb,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.