How To Duplicate Cells based on a specific quantity

Hi,


I have many, many rows of data and need to duplicate it on rows a specific number of times. In the example below, I need "fishing boat" and "florida" copied 50 times to rows below. I need "lure" and "florida" copied 100 times. Is there a way to do this easily without having to manually copy/past?

Thanks,
Mike

excel question.png

That is easily done.

right click on the row you want to copy and select copy.

left click on the row no on the left of excel of where you want to copy your row and drag down

Now right click and select "Insert Copied Cells"

Thanks, mehmetcik. I already know how to do that.

I'm looking for a way to MASS copy/paste all data at one time. I have hundreds of rows of data, so copying each one individually is too slow.

Any other ideas?

LOL

That wasn't clearly stated.

So how do I know which row you want duplicated and how many times?

Are you placing a number in column A for example?

Ahh I don't normally look at image files.

Your number is in column C

Mike,
Next time, you need to post a sample book, not a picture. Try the attached.
The code copies the new data in column D and E

I'm sorry. I see the download you sent with the cells copied, but what is the actual formula that copied them? That's all I need

I'm also not sure how to post a "sample book".

However I think that you are on the wrong track

Solution2 is probably what you really need.

Please Login or Register  to view this content.

Oh sorry, i see the code now. So i have no idea what to do with this?

I only know formulas. Can you help?

Wow

no-one answered for me.


Did you run the macros?

To run them

Click on developer on your excel tool bar then macros

two macros will be listed solution1 and solution2

run one, quit the file and run the other.

To see and edit the code

Click on developer

select a macro and click on edit

Hey, I'm sorry, but I have no idea what you're talking about. I don't see 'developer'.

Isn't there just a formula I can use to do this?

Ok, I'm learning. I found this macro on another forum at http://en.kioskea.net/faq/7546-excel...f-times#goprev

Sub CopyData()
Dim lRow As Long
Dim RepeatFactor As Variant

lRow = 1
Do While (Cells(lRow, "A") <> "")

RepeatFactor = Cells(lRow, "B")
If ((RepeatFactor > 1) And IsNumeric(RepeatFactor)) Then

Range(Cells(lRow, "A"), Cells(lRow, "B")).Copy
Range(Cells(lRow + 1, "A"), Cells(lRow + RepeatFactor - 1, "B")).Select
Selection.Insert Shift:=xlDown

lRow = lRow + RepeatFactor - 1
End If

lRow = lRow + 1
Loop
End Sub

It works perfectly for the case given. How would you modify the macro above so that it copies data in columns A and B, based on the value in column C?

Thanks for hanging in there with me.
Mike

If you bother to use VBA, why do you need to use another code while my code works.

I got it working now. Thanks.

Can anyone tell me how to save the VBA macro to my spreadsheet?

Also, if I run the macro by mistake, is there a way to UNDO it?

Thanks
Mike