Makro

[Esrei]

I want a macro that would copy a row onto a new sheet
transposed and print it. This I can record, I just want
the macro to do it for every line in the work sheet
induvidualy that is the part I need.

 

[bobf]

-----Original Message-----
I want a macro that would copy a row onto a new sheet
transposed and print it. This I can record, I just want
the macro to do it for every line in the work sheet
induvidualy that is the part I need.
.
Record the macro using relative references, after the

first paste, go back to original sheet, maybe to cell A1
as a reference cell, and drop down the rquired number of
rows and run the body of the macro again. You would need
some sort of counter to detect when all data had been
transferred.