I think I'd add another worksheet (hidden???) or in another workbook that
assigned names to teams:

Doe,John TeamA
Smith,John TeamB
....

Then I'd insert a new column A and use a formula to return the team name into
that column.

It sounds like there are 11 rows per person. I'm gonna guess that your real
data starts in row 2 (headers in row 1).

Then I'd use a formula like this in A2 and drag down:
=IF(MOD(ROW(),11)<2,A1,VLOOKUP(B2,Sheet2!A:B,2,FA LSE))

Then I could apply Data|Filter|Autofilter to show/hide the teams I wanted to
see/hide.

In fact, I could show all the teams I don't want and delete those visible rows.

I'd do my best to convince management to keep this workbook. You could hide the
worksheet and that column if they objected too much. (Just unhide them when you
need them.)


"Lisa H via OfficeKB.com" wrote:

Hi, I have 45 customer service reps weekly schedules in an excel
spreadsheet. They all are on one of 4 teams and are listed alphabetically
as so:
Doe,John start time break 1 lunch break 2
Monday 8:00 10:15 1:30 3:15
Tuesday
Weds
etc..

I need them to be sorted by team. I think a macro for each team would be
the easiest way to do this. I need code that would go through the
alphabetical list and search for an agents name and delte that row and the
10 rows below it. I have no idea where to begin or even how to be able to
set this up for 45 people! Please someone help!!

--
Message posted via http://www.officekb.com

--

Dave Peterson