So I have a table of values:
Col A Col B Col C
Row 1 23410 7000.00 6939.45
Row 2 23397 15000.00 11244.51
Row 3 27060 4000.00 3524.78
I need to be able to sort the values (up to 10 eventually) using an multidimensional array by Column B. The code will eventually be in a UserForm (and thus cannot rely on a spreadsheet sort).
The following code works on two conditions: 1. Only 3 rows of data (need up to 10) & 2. If it is in the order as shown (needs to be any order)
Please Login or Register to view this content.
Bookmarks