D
DJ Huff
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.
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.