I have a workbook with several worksheets. I add new sheets to the workbook often. The sheets contain the same type of data, but with different dates, amounts, vendors, etc. After I enter the new data, I will need to sort according to certain criteria. I am fine with this step. What is aggravating me in 2007 version is that I have to redefine the Sort By and the Then By for each worksheet. In the 2003 version, this defaulted for the woorkbook that I would be using. Is there a way to save the sort procedure so I don't have to redefine how to sort each time? I tried to record a macro (a process I am not very familiar with), but it appears it only works on the worksheet that it was created for. Also, the number of rows changes with each worksheet.