Is it possible to automatically move several rows of data based on a ranking for that group? I have several account names and each account has between 3 and 6 lines of data below it. Based on the months sales, the accounts need to be displayed in decending order on a worksheet. So now i import the data to fill each accounts data and then copy and paste values and then rearrange the accounts and their following rows. I just want to automate the rearanging to save that step. The problem is that each account has a different number of rows with data, and I can not display "unused" rows for accounts that dont have data in those areas. Thanks.