Macro to copy one row for n times in another worksheet.

Macro to copy one row for n times in another worksheet.


In sheet 1 I have data in 3 columns A, B, C.

e.g

A1 = XYZ, B1 = ABC C1 = BHY
A2 = BHU, B2 = ABD C2 = BNJ

I want A macro that copies Each row 50 times in another worksheet

In Sheet 2

A1 = XYZ, B1 = ABC C1 = BHY
A2 = XYZ, B2 = ABC C2 = BHY
.
.
.
.
.
.
A50 = XYZ, B2 = ABC C2 = BHY
A51 = BHU, B51 = ABD C51 = BNJ
.
.
.
.
.
.
.
.
A100 = BHU, B100 = ABD C100 = BNJ

This process should till the all end of file in worksheet 1.

Kindly do the needful.