You're saying that each team has its own worksheet but a rep may show up on more
than one sheet?

Or each team has its own worksheet and its own set of reps on that sheet?

If second case, DataFilterAutofilter should get you any single rep's data.

Print that.


Gord

On Tue, 1 Jul 2008 13:11:11 -0700, Newsgal
wrote:

There are multiple worksheets in the workbook. Each worksheet is for a team
and specific portions of each worksheet track the individual reps'
performance on that team. This is the part I'm hoping to get a custom print
on so when the rep is in the workbook/worksheet they can print just their
performance totals.