I have a fairly large worksheet that contains sales commission information.
I would like to automate that process as it currently takes 5-7 days to
complete the task. Here is what i would like to achieve:



1. sort by column B (this column contains sales rep numbers)

2.copy all data for each rep to a new sheet in the same workbook and give
the sheet name the sales rep's name.

3. format each sheet with Arial font, size 8.5, lines all around the data

4. insert a row at the top of each new sheet

5.put the sales rep name in B1

6.COMPUTE SUM OF COLUMNS L,M,N,O

7.Create a new column in R (give it name %)

8.compute column O as % N in column R



Hope I am clear.



Any help will be greatly appreciated.



Regards,



Naraine