Inserting a Row after a name

[Guest]

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.

 

[Nigel]

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.