I have 3 tables or sets of data that are on the same sheet. The first column in each set of data is the same header and the number can be the same in each set. I would like a way to sort these sets of data so that the rows will line up based on the value in the first column of each set.
See attached example
Here is a macro to do it.
Note the 3 named ranges (see attached)
Let me know if you need further assistance.
Please Login or Register to view this content.
Last edited by Croweater; 08-02-2021 at 11:33 PM.
Thanks for the help. I run the macro but it only seems to space the lines out more, they don't seem to align them. I will look more into the code to see what I can find.
Thank you again.
give this a try - macro on orange button
Please Login or Register to view this content.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
Beauty! Thank you!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
So I tried running it on my real life tables. My problem now is that the code aligns the "Sku" based by the row number. My sku numbers start at 10000 and go up to 50000. It sounds like the best way is using a macro, I just need to figure out a macro that will handle larger numbers and a lot more data.
Edit:
I changed some code around and switched it from + 3 to - 9997. That seems to keep the numbers at the top. Now I am seeing how much data in can process at once without freezing. If this works, I will mark it as solved.
Last edited by Pmuel; 08-03-2021 at 01:48 PM.
I was going to but when I use this with my real-world example it breaks down. If it is ok, I will leave it up as is and I'll continue to work on a solution myself.
Funnily enough, what that macro does is, take the example spreadsheet that you provided and creates your desired result as indicated in that original spreadsheet, exactly as per your request.Originally Posted by Pmuel
Nothing more, nothing less.
If your real world example is different in any way, you can't expect it to work without at least some minor modification.
this offers no actual help
Well that is exactly what you'll get from me in the future....'no actual help'.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks