Use the pivot table option no macro required.

In Excel use Data-Pivot Table and a wizard will open and allow you to set
up the report as you describe it.


--
Cheers
Nigel



"eternalrsx" wrote in message
...
I have no idea how to create a macro but need to put one together for a
worksheet. The worksheet in question has in Column A (sales rep name),
Column B (Sales Area), Column C (Homes in Sales Area) what I need is to
be
able to find the last instance of the sales rep name, then insert a row
that
calculates the totals in Columns D, E, F, G, & H which are all numeric
values. Then I need to insert an additional row to seperate those values
from the next sales rep. Can anyone tell me the best way to do this or a
macro that would do this. Any help would be appreciated. Thank you in
advance.