Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Makro
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. |
#2
|
|||
|
|||
-----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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
makro to return email | Excel Discussion (Misc queries) | |||
Makro olusturma nasil nedir nedendir? | New Users to Excel |