Copy A Set Of Rows "n" Times Along With Specific Headers

Hi All,

Need help on the attached problem description.

I have a set of rows and would like to copy n times.
There are two options to enter n:
a. The number "n" can be in a cell. the macro picks up the number in a particular cell and considers as n times
b. The macro gives us a dialogue box and the user specifies the no of time in the dialogue box.

Option B would be the best fit but if I presume the macro gets complicated in that case option A is only other option.

It would be really great if the seniors can help me on this.

Regards,
Sri