Help with lookup issue...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

aswert1223 - 27 Oct 2004 15:35 GMT

Hi,
First post, I hope I am asking a complete question!

_MY_SCENARIO:_[/B]
I HAVE AN AUTOMATED DAILY REPORT THAT LISTS PERFORMANCE STATISTICS O
AGENTS IN A CALL CENTER. EACH ROW OF THE REPORT HAS A LIST O
STATISTICS FOR AN INDIVIDUAL AGENT FOR THAT DAY. THE HEADINGS AR
SOMETHING LIKE:
[B]NAME | EXT. | CALL COUNT | AVERAGE CALL LENGTH | ETC. | ETC.

I made a workbook that has each of these daily reports on its ow
worksheet. I am building a monthly tracker to chart perfomance of th
agents against goals. I want to have another worksheet for each agen
that imports all the rows from all of the daily report worksheets tha
have that agent's name. I've searched the forum and cannot find a
applicable solution.

_QUESTION:
How do I bring complete rows from multiple worksheets based on text i
1 column?

Thanks in advance,

Jac

Reply to this Message

JulieD - 27 Oct 2004 16:32 GMT

Hi

two options
manually, open each file in turn ... turn on the autofilter .. (Data /
Filter / AutoFilter), filter for the agent, copy & paste the resulting rows
to the appropriate agent's worksheet.

programmatically - you will need a macro which will open each file in turn,
look for the agent's name, do the data / filter bit and copy the rows to the
appropriate agent's worksheet. This is not an impossible macro to write
....

HOWEVER, i would suggest that a better alternative is for you keep all of
the information in ONE worksheet say for a month ... as long as you're not
going to use all 65,536 rows in the month - then you can use the Data /
Filter / AutoFilter options to pull out information for one agent ... Pivot
Tables for summary purposes (and Pivot Charts) the Data / Form for entering
data etc etc etc.

Cheers
JulieD

> Hi,
> First post, I hope I am asking a complete question!
[quoted text clipped - 20 lines]
>
> Jack

Reply to this Message