I have a list of employees and the names of the teams that they work in. I
would like to transfer all of the names of people in one division onto
another worksheet, repeating this so that each worksheet shows a different
team list.

I have headed each page with the team name as per the column in the original
list and I have tried to use the Lookup functions which have only populated
the fields with the first name on the list.

I know i could sort and then cut and paste, but ideally i would like a
worksheet function as this may be a regular occurance,

Perhaps you'd like to try the set-up in this recent post
which closely fits what you're after:
http://tinyurl.com/5ejr2
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"matt_hull1979" wrote in message
...
I have a list of employees and the names of the teams that they work in. I
would like to transfer all of the names of people in one division onto
another worksheet, repeating this so that each worksheet shows a different
team list.

I have headed each page with the team name as per the column in the
original
list and I have tried to use the Lookup functions which have only
populated
the fields with the first name on the list.

I know i could sort and then cut and paste, but ideally i would like a
worksheet function as this may be a regular occurance,

Max,

You're a star! it worked like a dream! I had to adapt it a little as i have
over 500 staff in 30 different teams, so now I have an excel spreadsheet that
is over 23,800 Kb worth of formulas!

Thanks for your help.

"Max" wrote:

Perhaps you'd like to try the set-up in this recent post
which closely fits what you're after:
http://tinyurl.com/5ejr2
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"matt_hull1979" wrote in message
...
I have a list of employees and the names of the teams that they work in. I
would like to transfer all of the names of people in one division onto
another worksheet, repeating this so that each worksheet shows a different
team list.

I have headed each page with the team name as per the column in the
original
list and I have tried to use the Lookup functions which have only
populated
the fields with the first name on the list.

I know i could sort and then cut and paste, but ideally i would like a
worksheet function as this may be a regular occurance,

Glad it helped ! <g
Thanks for the feedback
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Matt_hull1979" wrote in message
...
Max,

You're a star! it worked like a dream! I had to adapt it a little as i
have
over 500 staff in 30 different teams, so now I have an excel spreadsheet
that
is over 23,800 Kb worth of formulas!

Thanks for your help.