yahoo800
asked on
vba: move data from columns to rows
Hi there, I need to automate moving colums to rows eg
eg when cell =x than i want to copy row and all columns (as rows) to another sheet eg
a 1 2 3
3 3 3
b 4 3 2
etc
eg when cell =x than i want to copy row and all columns (as rows) to another sheet eg
a 1 2 3
3 3 3
b 4 3 2
etc
------------
1 4 3
2 3 3
3 2 3
a x x
b x
b x x x
Use Copy/Transpose.
Please post a sample workbook as your example is not clear.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks! It seems to work fine for me! Is there any way to loop it for many cloumns and rows?
Possibly :) Need to see sample data before I comment.
Also since it is a different question than your original question, it has to go into a new post :)
Sid
Also since it is a different question than your original question, it has to go into a new post :)
Sid