I assume
vb has the push function as part of the array functions
myArray.Push( item to push )
Its been a while since programming
VB and I have now got a mac.
So basically you would search for the salesID then push to that array . . . simple.
myArray(salesID).Push(salesAmount)
Done!
See myArray(salesID) that selects out of the first array the set of data in the second array. The Push adds the data to the end of the list. Creating the next space in the array so you dont have to.
That is what you limit to 12. Keep track of the number of sales, push each time until 12 is hit!