Multiple Custom sorting with addition of a new column in between sort

[DrPacman07]

Hi Sir/Madam,

Good day!

I am currently working on a scenario ranking and assignment of the probabilities process wherein I need to sort an array of multiple columns (smallest to largest) based on a specific column. After which I need to add a new column (the set of probabilities) to be included in the array of columns for sorting. These processes are repeated until the array of columns are sorted X times ( X is based on a specific predetermined columns).

Example (smaller scale)
(Initial Data)
	A	B	C	D	E	F	G	H
1								Probability Generator
2	Probability Generator Factors	0.5431	0.4839		0.5431	(will change for each Column depending on the factors)
3				120	90		120
4
5	Data	1	2
6	0.079	0.057	0.005	0.01	0.018			0.3
7	0.09	0.007	0.011	0.033	0.07			0.4
8	0.011	0.065	0.064	0.043	0.072			0.1
9	0.01	0.067	0.068	0.023	0.074			0.2
First Sort Based on column 1 then add the generated probability
	A	B	C	D	E	F	G	H
1								Probability Generator
2	Probability Generator Factors	0.5431	0.4839		0.5431	(will change for each Column depending on the factors)
3				120	90		120
4
5	Data	1	2
6	0.079	0.057	0.005	0.01	0.018	0.3		0.3
7	0.01	0.067	0.068	0.023	0.074	0.4		0.4
8	0.09	0.007	0.011	0.033	0.07	0.1		0.1
9	0.011	0.065	0.064	0.043	0.072	0.2		0.2
Second Sort Based on column 2 then add the generated probability
	A	B	C	D	E	F	G	H	I	J
1									(X)	Probability Generator
2	Probability Generator Factors	0.5431	0.4839				0.4839	(will change for each Column depending on the factors)
3				120	90				90
4
5	Data	1	2
6	0.079	0.057	0.005	0.01	0.018	0.3	0.5			0.5
7	0.09	0.007	0.011	0.033	0.07	0.1	0.2			0.2
8	0.011	0.065	0.064	0.043	0.072	0.2	0.2			0.2
9	0.01	0.067	0.068	0.023	0.074	0.4	0.1			0.1

<colgroup><col span="8"><col><col><col></colgroup><tbody>
</tbody>

Note:
*The probability generator factors will be pasted below (X) to generate new probabilities
*This is just a small scale example of the problem, normally we do multiple times (100x)

I hope you can help me do a macro program to make my life easier.

Thanks A lot.