Here is my conundrum:
I am trying to make a list with five fields such as:
Person : Dollar Amount : Date : Type

On a seperate sheet in the same workbook I would like to import the data by
Person so that the whole line imports. For example:

Sheet One has the list:

Person: Amount : Date : Type
Bob : $15.00 : 02/05/07 : Inventory
Rick : $20.00 : 02/06/07 : Stock
Bob : $17.50 : 03/15/07 : Reciepts
Sam : $5.00 : 03/18/07 : Stock

Sheet Two has the totals by person:
Bob
$15.00 : 02/05/07 : Inventory
$17.50 : 03/15/07 : Receipts

Sam
$5.00 : 03/18/07 : Stock

Rick
$20.00 : 02/06/07 : Stock

I am trying how to figure out how to have the data automatically update on
sheet two when a new line is added to sheet one. Including adding a new row
to accomodate the new line of data.