A pretty basic excel macro question

Closed
Report
-
 joe -
Hello,

I need some helping creating a macro that will copy a column of data from one sheet and transpose it onto a row in another sheet. Thats the easy part. The thing that I cant figure out how to do is to make a macro so that every time I run it, it will put the data on a new row in sheet2. Thank you in advance for any help I can get with this.

Yosef

2 replies

May I know what type of excel sheet are u talking about. excel 2007 or 2003?
Let me know.
0
Hey Chris, Im using excel 2007.
0