Copy and paste row x number of times

[ClaireD]

Hi all,

I need to create a macro that will copy and paste a row a certain number of times depending on the number a user types into a cell (let's call is L1 for argument's sake). This only needs to apply to one sheet in the excel (Match selection)

Any ideas,

Thanks,

Claire

 

[BarryL]

Hi,

where is it copying it from/where is it pasting to/does it need to meet any criteria?

 

[ClaireD]

Hi,

where is it copying it from/where is it pasting to/does it need to meet any criteria?

Hi Barry,

It will need to copy row 13 on the same sheet. It would need to post in the row below. Row 13 would need to be included in the count so if the user types 12 then row 13 would need to be copied and pasted 11 times.

Most of the cells that are being copied and pasted are checkboxes however:
Column A =TEXT(B13, "dddd") (varies for each cell in the column)
Column B & C is a data validation list that is the same for each cell in the column
Column D is free text

Thanks,

Claire