Reply to thread

Message

[QUOTE="rjr, post: 6200250"]
****Hadn't thought about it but you've got me thinking. I don't have a need
for all 10 rows since the aging will be in one cell and the count in
another. It won't hurt anything to have them on the sheet in col A and col B
though..   So see if thismakes sense. We have A (aging) and B (Co Code) with
all 10 entries for this example. Below that we have the second CO Code and
however many entries there are there. and so on......... What about labeling
cell F1 as "Aging"; cell G1 as "CO CODE" and H1 as "Total"......... Then
cell F2 would have the oldest aging for each "CO CODE"; G2 would have each
of the four "CO CODE"'s listed and cell H2 would have the total count for
that CO.

This would look something like this
F          G              H
1    Aging    TotDays    CO Code
2        15          10          3DFGU
3        10           4           3DFGV
4         9            2            3DFGW
5         2           12          3DFGX

The actual numbers could remain, with a space between eace column to
separate them, with the totals as here. I will be using this particular code
to select these items and make this entry for at least 20 worksheets, so
I'll put the button on the toolbar so when it's imported I can simply hit
the button. Each sheet will then be linked to a master sheet to collect the
data. This will be done daily and all imported sheets will have the same
name, so each day it will replace the old data. That's why it's important
for the F G & H columns to stay the same because of the reference to the
named links.
I really appreciate the help and questions Otto, Thank you.
BOB
[/QUOTE]

Verification