How do i transfer certain lines from one list to another

M

matt_hull1979

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,
 
M

Matt_hull1979

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert name and adress from a list in a word document 1
Space at end of multi page list to accommodate new entries 1
How to implement two shifts per day with multiple teams 0
Using a cell's value to copy another cells info to another workshe 1
Auto populate value from one task to another in MS PROJECT 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
New computer, how do i move outlook 365 ENTIRELY? 0
list items from one table in another table based on value in first table 2

Top