Danish
03-07-2007, 09:14 AM
We have a large data set distributed across to worksheets in the same workbook.
The two sheets are named: MAK & MKW
The first observation in each sheet is located in cell B10 and ends in FZ10
the corresponding names to the data is located in cell B4 and ends in FZ4 in
both sheets.
We need to sort row 10 in ascending order and it is important that the names
are linked to their observation and finally load it into an array.
So we end up with an 2*362 array/matrix sorted according to the observations
(it is not important for us to see it explicitly in a new worksheet)
It is important that it is VBA code because we have over 400 rows and we don't want do it in access.
Thank you
The two sheets are named: MAK & MKW
The first observation in each sheet is located in cell B10 and ends in FZ10
the corresponding names to the data is located in cell B4 and ends in FZ4 in
both sheets.
We need to sort row 10 in ascending order and it is important that the names
are linked to their observation and finally load it into an array.
So we end up with an 2*362 array/matrix sorted according to the observations
(it is not important for us to see it explicitly in a new worksheet)
It is important that it is VBA code because we have over 400 rows and we don't want do it in access.
Thank you