See example below...

COL A COL B

document1 30
document1 45
document2 15
document1 33
document3 55
<blank 32
document2 2
document1 42
document2 9
document3 44
etc...

I want a total for each document in a separate table, either on this same
sheet or on a separate summary worksheet. E.g.:

document1 total = 150
document2 total = 26
document3 total = 99
<balnk total = 32

The kicker is that I don't want to specifically name the documents to
search, I want Excel to figure out the document names by searching down COL A
to the last occurance of information (may have to search COL B to find last
occurnace of information) and indicating what document names exist. Thus,
Excel would find document1 and place it and its total in a table, then find
document2 and place it in the row beneath document1 total in the table, etc.
If a routine must be developed, I would rther it be a Function than a
Procedure so it works dynamically.

--
Regards,

DJ Huff, PhD, PMP, CISA, ITIL

Use a Pivot Table. See:

http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
Gary''s Student - gsnu200846


"DJ Huff" wrote:

See example below...

COL A COL B

document1 30
document1 45
document2 15
document1 33
document3 55
<blank 32
document2 2
document1 42
document2 9
document3 44
etc...

I want a total for each document in a separate table, either on this same
sheet or on a separate summary worksheet. E.g.:

document1 total = 150
document2 total = 26
document3 total = 99
<balnk total = 32

The kicker is that I don't want to specifically name the documents to
search, I want Excel to figure out the document names by searching down COL A
to the last occurance of information (may have to search COL B to find last
occurnace of information) and indicating what document names exist. Thus,
Excel would find document1 and place it and its total in a table, then find
document2 and place it in the row beneath document1 total in the table, etc.
If a routine must be developed, I would rther it be a Function than a
Procedure so it works dynamically.

--
Regards,

DJ Huff, PhD, PMP, CISA, ITIL

Thanks, but I want the table to reflect immediate changes, such as if I add a
document name where it was previously <blank, yet with a $ amount. I did
create a pivot table and it showed me item counts rather than total $ amounts
for the document. I'll play more with pivot tables, but my first pass was
not impressive.
--
Regards,

DJ Huff, PhD, PMP, CISA, ITIL


"Gary''s Student" wrote:

Use a Pivot Table. See:

http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
Gary''s Student - gsnu200846


"DJ Huff" wrote:

See example below...

COL A COL B

document1 30
document1 45
document2 15
document1 33
document3 55
<blank 32
document2 2
document1 42
document2 9
document3 44
etc...

I want a total for each document in a separate table, either on this same
sheet or on a separate summary worksheet. E.g.:

document1 total = 150
document2 total = 26
document3 total = 99
<balnk total = 32

The kicker is that I don't want to specifically name the documents to
search, I want Excel to figure out the document names by searching down COL A
to the last occurance of information (may have to search COL B to find last
occurnace of information) and indicating what document names exist. Thus,
Excel would find document1 and place it and its total in a table, then find
document2 and place it in the row beneath document1 total in the table, etc.
If a routine must be developed, I would rther it be a Function than a
Procedure so it works dynamically.

--
Regards,

DJ Huff, PhD, PMP, CISA, ITIL

I changed it to reflect $ amounts and that is fine...I just need it to
dynamically change rather than having to manually refresh it. How can I
automatically refresh this when an update to a row within the pivot table is
updated?
--
Regards,

DJ Huff, PhD, PMP, CISA, ITIL


"Gary''s Student" wrote:

Use a Pivot Table. See:

http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
Gary''s Student - gsnu200846


"DJ Huff" wrote:

See example below...

COL A COL B

document1 30
document1 45
document2 15
document1 33
document3 55
<blank 32
document2 2
document1 42
document2 9
document3 44
etc...

I want a total for each document in a separate table, either on this same
sheet or on a separate summary worksheet. E.g.:

document1 total = 150
document2 total = 26
document3 total = 99
<balnk total = 32

The kicker is that I don't want to specifically name the documents to
search, I want Excel to figure out the document names by searching down COL A
to the last occurance of information (may have to search COL B to find last
occurnace of information) and indicating what document names exist. Thus,
Excel would find document1 and place it and its total in a table, then find
document2 and place it in the row beneath document1 total in the table, etc.
If a routine must be developed, I would rther it be a Function than a
Procedure so it works dynamically.

--
Regards,

DJ Huff, PhD, PMP, CISA, ITIL