I have a workbook that I've set up with 2 worksheets. One contains the
data(HIMD), which is updated every other week by importing a text file. The
other worksheet(LSE) is the 'pretty' worksheet for my boss that I'm trying to
set up. It has the following titles at the top:
A B C D E F
G
10-20days 20 days
ID Type Name # accts #days # accts #days

The data worksheet(HIMD) contains these columns:

A B C D E F G
H
acct# Occ# Rec Date Rec Stat ID Type Name # of days

Is there a formula I can use to pull the data into the LSE worksheet that only
has accounts 10-20 days and 20 days?

An example of what I would want it to look like is this:

A B C D E F
G
10-20days 20 days
ID Type Name # accts oldest # accts oldest
80 MD Fak Name 3 19 2
182

(data starts on row 3)
so, Fak Name has a total of 3 accounts, the oldest being 19 days, and Fak
Name also has 2 accounts with the oldest being 182 days.

Can anyone tell me how to do this? Or maybe even an easier way to do it?
I've got to set this up for a user to do bi-weekly that knows little to
nothing
about Excel. Am trying to get it to where all she has to do is import the new
text file and it will automatically fill in the 'pretty' worksheet and then
she
can print. Pipedream? Would appreciate any help!!!!

I think I said this wrong.......Fak Name has a total of 3 accounts that are
between 10 and 20 days, the oldest being 19 days, and Fak Name also has 2
accounts that are older than 21 days with the oldest being 182 days.


"Tasha" wrote:

I have a workbook that I've set up with 2 worksheets. One contains the
data(HIMD), which is updated every other week by importing a text file. The
other worksheet(LSE) is the 'pretty' worksheet for my boss that I'm trying to
set up. It has the following titles at the top:
A B C D E F
G
10-20days 20 days
ID Type Name # accts #days # accts #days

The data worksheet(HIMD) contains these columns:

A B C D E F G
H
acct# Occ# Rec Date Rec Stat ID Type Name # of days

Is there a formula I can use to pull the data into the LSE worksheet that only
has accounts 10-20 days and 20 days?

An example of what I would want it to look like is this:

A B C D E F
G
10-20days 20 days
ID Type Name # accts oldest # accts oldest
80 MD Fak Name 3 19 2
182

(data starts on row 3)
so, Fak Name has a total of 3 accounts, the oldest being 19 days, and Fak
Name also has 2 accounts with the oldest being 182 days.

Can anyone tell me how to do this? Or maybe even an easier way to do it?
I've got to set this up for a user to do bi-weekly that knows little to
nothing
about Excel. Am trying to get it to where all she has to do is import the new
text file and it will automatically fill in the 'pretty' worksheet and then
she
can print. Pipedream? Would appreciate any help!!!!

anyone???

"Tasha" wrote:

I have a workbook that I've set up with 2 worksheets. One contains the
data(HIMD), which is updated every other week by importing a text file. The
other worksheet(LSE) is the 'pretty' worksheet for my boss that I'm trying to
set up. It has the following titles at the top:
A B C D E F
G
10-20days 20 days
ID Type Name # accts #days # accts #days

The data worksheet(HIMD) contains these columns:

A B C D E F G
H
acct# Occ# Rec Date Rec Stat ID Type Name # of days

Is there a formula I can use to pull the data into the LSE worksheet that only
has accounts 10-20 days and 20 days?

An example of what I would want it to look like is this:

A B C D E F
G
10-20days 20 days
ID Type Name # accts oldest # accts oldest
80 MD Fak Name 3 19 2
182

(data starts on row 3)
so, Fak Name has a total of 3 accounts, the oldest being 19 days, and Fak
Name also has 2 accounts with the oldest being 182 days.

Can anyone tell me how to do this? Or maybe even an easier way to do it?
I've got to set this up for a user to do bi-weekly that knows little to
nothing
about Excel. Am trying to get it to where all she has to do is import the new
text file and it will automatically fill in the 'pretty' worksheet and then
she
can print. Pipedream? Would appreciate any help!!!!