Hi Ruth

If you are only wanting to provide a printed copy to each manager, then
obviously you don't need to copy the data to another sheet.
Filtering on column J and column S, then printing will provide your
report.

If you did want to extract to another sheet, then instead of Autofilter,
you could use Advanced Filter.
For more help on how to do this, take a look at Debra Dalgleish's site
http://www.contextures.com/xladvfilter01.html#ExtractWs

You could create 5 sheets, 1 for each manger with the necessary criteria
set up, then refresh each sheet and print.

PS Is there any way to edit/correct my original question? I couldn't
find
any moderator contact info but maybe I was looking in the wrong place.
:-)

No, not as far as I am aware. If I have made a mistake, I post a reply
to my own message, with the correct and it shows up in the thread, so
others watching the thread should pick up the amendment.

--
Regards

Roger Govier


"Ruth_J" wrote in message
...
Hi Pete,

I'm the clerical prepartory person for new work coming into an office
and
have 5 managers being assigned technical jobs (manager's id or blank
if not
assigned yet is in column J). They are to complete the job without
regard to
who originated it. If the job cannot be completed, then it goes back
to the
originator with notes on what is missing, incomplete, etc. (S column
is the
manager's id that originated the job). The rest of the fields in the
spreadsheet are filled with project data. The manager who originated
the job
& the manager who was assigned the job to complete is seldom the same
person.
Rather than expecting the manager to access the spreadsheet on our
network
and sort their own, I'm required to hand out a paper spreadsheet twice
a week
to each manager showing his open jobs (column J) and his jobs that
could not
be completed (column S). I'm trying to avoid a lot of cut & paste or
printing two spreadsheets for each person. We do not have the budget
for
formal training (I learn out of necessity...laugh) and cannot justify
it as I
rarely create spreadsheets. Most of my training comes from the Excel
Help
Menu & asking questions.

(FYI-I extract the data daily (57 columns) from an incompatible
database to
a text file, import the text file into Bk1 Wrksht1, extract the
columns I
need via linking to Wrksht2, apply formulas to two new columns and
then
copy/paste the data & format only to Bk2 Wrksht1. Bk2 Wrksht1 is open
to
viewing & sorting by all.)

Sorry if this is TMI but...you asked (chuckle)...thanks bunches,
Ruth

PS Is there any way to edit/correct my original question? I couldn't
find
any moderator contact info but maybe I was looking in the wrong place.
:-)