Problem Explaination (Long Version)
I have a worksheet that needs to generate a 14 to 15 page report. The range of cells I need to sort in the worksheet is from A6:BB147 and it needs to be sorted by col D, then Col C, and Finally Col E. Once sorted I need to create a new worksheet and process through each row of the sorted cells and input the data in the new worksheet in the right format. Now I've figured out how to create new worksheets and copy a template to handle the formatting and I figured out how to move the data across. I can generate the report fine if I first sort the table by the three keys and then run the macro. The problem is this excel is for a someone else and they prefer to look at the main worksheet sorted by col D only. So I want to leave the main worksheet sorted by col D, but when the macro runs I want it to sort the correct cell range in the correct sort order and use that to generate the report. Any ideas.
Problem Explaination (Short Version)
I need to sort a range of cells in one worksheet by three seperate collumns and then loop through each row of the sorted range.