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.

Though a macro for this would be the best solution a quick but a semi-
automated method would be to create a pivot table .Assuming that the
data on sheet1 can max goto 5000 rows ,specify a data selection for
pivot table mapping to 4 columns and 5000 rows. In the pivot specify
Person Date and typeas fields on the row side and amount in case of
values. This way it will automatically create pivot as shown below and
everytime you add a new row you can refresh the data to get latest
updated amounts

Row Labels Sum of Amount *
Bob * * 32.5
* 02/05/07 * 15
* Inventory 15
* 03/15/07 * 17.5
* Reciepts 17.5
Rick * 20
* 02/06/07 * 20
* Stock 20
Sam * 5
* 03/18/07 * 5
* Stock 5
Grand Total 57.5


HTH

Regards
Anirudh
On Jan 11, 4:08*am, The working poor <The working
wrote:
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.