Copy Data from Different Tab and Paste the Data X Number of Times

[Lyndy Januszewski]

Hello!

On Sheet1, I have the following values beginning in Cell A4 (these values are also part of a Named Range):

Cat
Dog
Mouse

I would like to paste these values into Sheet2 beginning in Cell G2. I would like to paste them in the number of times specified in Cell B2 of Sheet2. So for instance, if Cell B2 in Sheet2 says 4, Column G would say:

Cat
Dog
Mouse
Cat
Dog
Mouse
Cat
Dog
Mouse
Cat
Dog
Mouse

Is there a macro that would accomplish this? Thank you!

[Trebor76]

Hi Lyndy,

Try this:

Please Login or Register  to view this content.

Regards,

Robert

[:) Sixthsense :)]

Try this code...

Please Login or Register  to view this content.

[AB33]

Duplicate post

http://www.excelforum.com/excel-prog...el-2010-a.html

[Lyndy Januszewski]

Thanks Sixthsense. This is almost exactly what I need.

Instead of hardcoding the "copy to" spreadsheet in the macro (i.e. Set wRes = Sheets("Sheet2")

Is it possible to have the macro copy the data to the active sheet regardless of its name? How would I update the macro to accomplish this?

Thank you!

[Lyndy Januszewski]

AB33 - This is not a duplicate post. I did post twice to the forum - once with a need to copy data within a single sheet in Excel and a different question about needing to copy data from a different sheet in Excel to another one. Thank you for any input you can provide.

[:) Sixthsense :)]

Change this

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

[Lyndy Januszewski]

Just what I needed. Thank you!