Select entire row to copy

[miles44]

I have a worksheet with above 100 rows of data

I would like a macro that will select one row at a time, copy and paste the row to another worksheet.

Then go to the next row and do the same thing.

[BadlySpelledBuoy]

Are you copying them all to the same worksheet?
If so, why the need to do it one row at a time?

BSB

[miles44]

Actually, when I paste them, I want to use the TRANSPOSE function of the paste

[BadlySpelledBuoy]

That's quite an important detail to omit from your original post.

Could you attach a sample workbook showing your data layout and desired result?

BSB