Im new to macros so need a little help
Task: Need a macro to
1)insert a line inbetween the change in name
2)insert a (-sum) of the amounts for that person
3)insert the person's name

My Data:
[Date ] [Name & Exp ] [amount]
[1/1/11] [John Doe Fedex] [5.00]
[1/5/11] [John Doe Stapes] [60.00]
[1/6/11] [Adam Smith Rental] [250.00]
[1/8/11] [Adam Smith Hotel] [299.00]

Ideal Outcome:
[Date ] [Name & Exp ] [amount]
[1/1/11] [John Doe Fedex] [5.00]
[1/5/11] [John Doe Stapes] [60.00]
[John Doe] [-65.00]
[1/6/11] [Adam Smith Rental] [250.00]
[1/8/11] [Adam Smith Hotel] [299.00]
[Adam Smith] [-549.00]