Link to home
Start Free TrialLog in
Avatar of yahoo800
yahoo800

asked on

move data from columns to rows - loops

Thats the continuation of the question: https://www.experts-exchange.com/questions/26783239/vba-move-data-from-columns-to-rows.html

So:
Is there any way to loop it for many columns and rows?

Book1.xls
Avatar of Michele Segato
Michele Segato
Flag of Italy image

Can you post  a sample file?
From your previous example it is not clear how many rows and columns you need.
It is not clear how to check where the data rows end and where the selection rows begin.
Are you sure that you are using the correct approach to your problem?
Perhaps we can help for the solution if we know even the original problem, that is whydo you want select the rows in that strange way.
I am sorry, now i see the attached file.
But it seems different from the first question.
Can you please write what do you expect as result, since the selection in book1.xls?
Avatar of yahoo800
yahoo800

ASKER

thats the desired output
I slightly changed the table from example in book1
cheers
Book2.xls
i have lots of files like this and each of them contains more than hundred columns. It would be nice to automate it so that it reckognize nr of rows/columns ie len>1
ASKER CERTIFIED SOLUTION
Avatar of Michele Segato
Michele Segato
Flag of Italy image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
if u email me on weeerty at poczta.onet.pl ill email u back the oryginal file as there are still some minor things which I cant sort out (eg it copies only data from first and second cell of every column)