Hi.
I have (column A) and 200 lines in sheet1 would traspor to 200 columns in sheet2.
Rows (sheet1)
1
2
3
...
200
To
Columns (sheet2)
A B C ... GR
thank you
Hi.
I have (column A) and 200 lines in sheet1 would traspor to 200 columns in sheet2.
Rows (sheet1)
1
2
3
...
200
To
Columns (sheet2)
A B C ... GR
thank you
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Hello marreco,
You can use the following VBA code to do this. Just be sure to chage the sheet names if they are different.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Or you could just copy/paste transpose to the new location?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
hi Leith Ross
was great!
one more question.
as if I do I always have more lines?
ie I have 200 lines, on another occasion I have 250 lines, 300 lines on another day.
leave the code as predict the exact number of lines?
You can add a variable to Leith's code to find the last row...
Please Login or Register to view this content.
HTH
Regards, Jeff
Hi
Very good!!!!!!!!
thank you all
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks