Code for auto filter and arrange specified cell values in matrix

[vedamv]

Hi

I have this spreadsheet with two variables: PROBABILITY and IMPACT in two different columns & each falling in the scale of 1to 5. Now each record (data in a row) may have a value between 1 to 5 for PROBABILITY as well as IMPACT.

First I need to sort the data in the worksheet in ascending order (keeping the reference number of tow item in the sort scope) with records starting with PROBABILITY of 1 and IMPACT ascending from 1 to 5 and so on until records with PROBABILITY of 5 and IMPACT ascending from 1 to 5.

The table will look like the tables in image attached: table left (Before sorting) and right (after sorting)

Now I need to copy the reference numbers in the matrix presented at the bottom of the image in such a way that all the reference numbers with Probability 1 and varying Impact score will be sequnetially pasted in the cells of the squares with Probability 1 and Impact 1 to 5 (bottom most square blocks in the graph.

I know how to do the sorting through Data --> Sort option. Can some one help me with a macro (VBA code) to copy the reference numbers in the cells in the graph according to the values of Probability and Impact matrix.

your help is highly appreciated.

Thanks
Venkat