Excel subtotal

[kingsley]

I have a large file with a layout (main area only) as
follows:
Name Expense .............
Brown, John $100
Brown, John $150
Brown, John $200
Doe, Jane $110
Brown, Jane $130
Brown, Jane $210
..
..
..
I need to subtotal each person's expense (names may be
different each period I do this)and copy/export the
expense items and subtotals for each person to a separate
worksheet to be emailed to them. There may be 30 names and
2000 lines of data. Is there a way to autonomate this
process (rather than subtalling then copying each person's
items to a new worksheet individually)? This takes hours
to do.

 

[CLR]

Check out the Data > Subtotals feature........

Vaya con Dios,
Chuck, CABGx3

 

[Jennifer]

Have you tried using the autofilter. You can just pick the
name and it will select all rows that have to do with the
name selected. Select your everything including the
headers <>Data<>Filter<>Auto Filter<> Follow the
directions. Or you could also use a formula like =dsum().
This will sum anything in your database according to your
specifications. Hope this is of some help. Jennifer

 

[Dave Smith]

If D2 contains one of the names then a formula like this will give you the
total for that name:

=SUMPRODUCT(($A$2:$A$7=D2)*$B$2:$B$7)

Use Advanced Filter to copy unique records from the name column to get the
list of names.

If this isn't clear, let me know.

-Dave