Need Macro to repeat row specific number of times

[KimberlyS]

I have never built or used a macro before and need very clear step by step instructions. I am just assuming that a macro is the answer to what I am looking for but if there is a simplier solution that would be fantastic.

I need to be able to repeat a row of data a specified amount of times.

Example:

3 Yellow James
2 Green Mark
5 Purple Sue
1 Orange David

Needs to look like:

3 Yellow James
3 Yellow James
3 Yellow James
2 Green Mark
2 Green Mark
5 Purple Sue
5 Purple Sue
5 Purple Sue
5 Purple Sue
5 Purple Sue
1 Orange David

If anyone has a solution, I would really appreciate the help!

[Joakim N]

Try this

Repeat_Rows.xlsm

[KimberlyS]

Wow. This is exactly what I need but how can I apply it to my own spreadsheet? The rows that I am using have more columns.

[Joakim N]

Can you send me your workbook and I will apply the code for you.

[KimberlyS]

Unfortunately the data in my spreadsheet is confidential. Would you be able to walk me through building the macro on my own or is this too difficult? The spreadsheet I will be using has 11 columns and 2000 rows.

[Joakim N]

I have rewritten the code so it deals with unknown number of rows & columns. The result will be placed in Sheet2.

Here is the workbook where you can see the commandbutton and the code. In your workbook:
1. Copy and Paste the code in a module (Hope you are a little familiar with VBA Editor)
2. Add a commandbutton in your worksheet and connect the subroutine

Repeat_Rows(1).xlsm

Here is the code:

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Another:

Please Login or Register  to view this content.

[KimberlyS]

This worked perfectly! Thank you so much!