Replicate/copy Rows based upon Another Cell

[rka81]

Hi, am hoping that this is a reaal easy quick one for you guys....

I need a macro (can be done by using a button) where a range within a row is copied and pasted below this range. The number of copies/replicated rows need to be based upon a number that is input into another cell.

So if A1 equal 5, then range A5:A10 is copied and pasted below this row 5 times.....

I have played around several times and done a few searches within this forum but cannot seem to find a similar post...

thanks in advance

[shg]

Replicates the selection? Can you give another example?

[rka81]

Replicates the selection? Can you give another example?

Hi, i have attached a simple version with a few notes which should hopefully show what i mean

Thanks again

[shg]

My question is, how do you know which row is to be copied?

Edit: Just guessing,

Sub x()
    With Selection
        .EntireRow.Copy
        .Offset(1).Resize(Range("A3").Value).Insert
    End With
End Sub

[rka81]

My question is, how do you know which row is to be copied?

oh sorry, it would just be a specified row.

I am basilcally creating a daily planner and depending on how many days there are specified - that is how many row i want copied from, say the top row, which will have validated drop down menus in (with various activities)

sorry if i wasnt (or still arent clear)

[shg]

Specified how?