Hi everyone. I have an array of cells with multiple records in each cell. I need to sort the data in a way that each type of record is located in a separate column.
Types of records in the cells:
1. Starting from 45...
2. Starting from 10...
3. Starting from 40...
4. Starting from 2...
So I need that all records that start from 45 would be located in the same column; records that start from 2 - in another column and so on.
Thank you for advice.
Data.xlsx
This was a fun exercise, thanks. It does take a few seconds to run, so likely loading all your data into an array would be a faster approach, but hey, that ain't my style.
Please Login or Register to view this content.
I'm interested in starting a career working with VBA, if anyone knows of any opportunities!
Thank you, walruseggman! The code runs as expected. I forgot to mention one critical element, though
Each line has a Record ID, so references from the line should stay in the same row and stay attached to the original Record ID
(please see the updated data file attached).
For example: row 2 has the Record ID 38374287, so all references from this row should stay attached to this record ID, which I will need to reconcile with other documents later.
Sorry for incomplete question...
Sorry, I don't understand what you want. Can you please attach a sample output of what you want the code to do? Ten or so lines, just enough to make it clearer what the output is.
Absolutely and thank you for looking into this.
In the attached file - DATA = source data, SAMPLE OUTPUT = desired output results
Thanks!
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