Hi There,
I am having trouble with row and columns.
Actually I have data in one row.
right now I have one row and 4 columns
Row1= A B C D
now I want to Take this data from this row and paste it under one column on different sheet, but on 4 rows.
A
B
C
D
and rows can grow, some times, data is going to be only in 2 rows, and some times it could be 20 rows.
So can you please tell me a way how to find out the last row. One you run the macro, it should always look all rows with data and put them in column.
Like data from row 1, should go to column 1 in next sheet.
and row 2 data should go to under column 2 in next sheet and so on.
Please help me out here. I shall be thankful to you.
Thanks
This message was edited by amna77 on 2002-05-10 14:38
I am having trouble with row and columns.
Actually I have data in one row.
right now I have one row and 4 columns
Row1= A B C D
now I want to Take this data from this row and paste it under one column on different sheet, but on 4 rows.
A
B
C
D
and rows can grow, some times, data is going to be only in 2 rows, and some times it could be 20 rows.
So can you please tell me a way how to find out the last row. One you run the macro, it should always look all rows with data and put them in column.
Like data from row 1, should go to column 1 in next sheet.
and row 2 data should go to under column 2 in next sheet and so on.
Please help me out here. I shall be thankful to you.
Thanks
This message was edited by amna77 on 2002-05-10 14:38