VB Array Sorting (EBCDIC)
Posted on 2010-11-29
Hi Guys, Im trying to create a sub that takes an array, sorts it in EBCDIC standard, then assigns a sequence number to it. Let me explain to start.
I have a two column set of data. Lets call them MAIN and SUB so:
I want to join MAIN and SUB together, do a sort within the array in EBCDIC standard. Once I have this, for each row in the array, i want to assign it a sequence number like follows:
MAIN SUB SEQUENCE
ITEM1 SUB1 1
ITEM1 SUB2 2
ITEM1 SUB3 3
ITEM1 SUB4 4
ITEM2 SUB1 1
ITEM2 SUB2 2
so essentially the sequence is the position of the SUB entry within a unique MAIN.
Now ive not worked with arrays with more than one element to it so im completley at the mercy of you guys on this as im really not sure where to start.
Whilst i've also listed this question in the excel forum - all of this needs to be done in vba and not on any worksheets (only using one of excels addin functions to receive the dataset from a remote server).