Copy horizontal row to vertical column

I am new to vba and would like some help. Is there an easy way to copy row 1 of sheet1 to column a of sheet 2.


How would you make a loop that would continue this logic for 20 rows.



Appreciate any advice,

April

Hi,

If I understand correctly you can use the Tranpose feature in Excel

Please Login or Register  to view this content.

hope this helps!
mccreaso

no need to select and copy

Please Login or Register  to view this content.