Retrieving data into worksheet from another worksheet in same work
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!!!!
|