I need some help to create a macro that will arrange multiple values in columns for all available rows such that they form a matrix.
I have attached an example of the before and after macro results.
The number of columns and rows may vary.
Any help would be much appreciated.
wk
Why is there a gap in column E where I assume a 4 would go however there is no gap between Column I with the value 9 and Column J with the value 11. Same for P having 17 and Q having 20? Is that a mistake otherwise I do not understand the logic. If it is a mistake then you could use
You will need to have a sheet named After
Please Login or Register to view this content.
Last edited by smuzoen; 07-03-2012 at 12:22 AM.
Hope this helps.
Anthony
Pack my box with five dozen liquor jugs
PS: Remember to mark your questions as Solved once you are satisfied. Please rate the answer(s) by selecting the Star in the lower left next to the Triangle. It is appreciated?
Thanks for your help! Your method to arrange works for me as well.
However, there are some situations where the macro doesn't work when the numbers change (Runtime error '13', Type mismatch).
I have attached Example2.xlsx as one situation where it doesn't work.
Appreciate your help to solve this.
The reason this did not work with the number set was due to the fact I had not allowed for the situation where there is only one number in the row. In this case there was no array hence the error. Will the situation ever arise that there will be no numbers in a row? Use
This will erase the numbers in the after sheet prior to re-arranging the values.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks