Have you tried Autofilter, Jaye?
http://www.officearticles.com/excel/...soft_excel.htm
(MrExcel and I have a running joke about how I "don't do pivot tables")
************
Anne Troy
www.OfficeArticles.com

"Jaye" wrote in message
...
I know my way around Excel pretty well, though not an expert.

I have created my an Excel file with information for each player in a
sports league whose playing rights is held by one of our teams.
Essentially, the file serves as a crude player database with the following
column headings saved as named arrays:

Master (this is a unique ID number)

Last_N

First_N

Team_ID (number assigned to a specific team)

Team (text name for team)

Status (designates player status by number denoting 1 for active,
2-inactive, 3-suspended...)

Jersey (uniform number)

Pos.

Ht.

Wt.

Birthdate

Age

Hometown

College

Each row has also been saved as a named array starting with P_1 through
P_329, noting that there are 329 players in the League.

Is there a method (without using Pivot Tables) to produce a roster of
active players for each team in a separate list?

If team=x and status=1 then display Jersey, Last_N, First_N, Pos., Ht.,
Wt., Birthdate, Age, Hometown, College for Team X

If team=y and status=1, then display Jersey, Last_N, First_N, Pos., Ht.,
Wt., Birthdate, Age, Hometown, College for Team Y