I have a spreadsheet setup for 4 different points of data. Each set of data includes up to 24 numbers. The sets are in the spreadsheet as such, C6:N7, C8:N9, C10:N11, C12:N13. What I would like to happen is when a macro is run to look at each set of data and place them rearrange them numerically based on the highest number in hte set. The cell structure will not change. So the sets will still reside in the same sections of the spreadsheet, i.e. C6:N7, C8:N9, C10:N11, C12:N13. I need the lowest set of numbers first and up from there. Ex. if you eneted 100, 200, 300, 400, 500 etc. in the first section,C6:N7. And then 1, 2, 3, 4, 5 etc. in the next section, C8:N9, the macro would then rearrange the set so that the lower numbers fell in the cells C6:N7, and the larger fall into C8:N9. Keeping in mind there can be up to four sets of numbers. Also there are going to be titles for each set of data in C5, D5 etc. that will need to follow the sets of data.