Need help filtering a list in a new worksheet from a master list

[Burton]

I need your help, I am an average Excel user, using our office provided Excel 2003. I am trying to create a sub-list from a master list based on a column criteria.
Basically, we have a large group of people that are now being split into 3 different sub groups, but still part of the whole. I would like to only upkeep the master list by assigning one of 3 managers to each employee and then having Excel place the employee's info (5 columns) into a seperate worksheet based on the manager assigned (3 seperate worksheets, one for each manager)
I have searched through books and Excel help, but still cannot find any formula that can return multiple lines based on one criteria. Am I out of luck and forced to maintain this database with an Auto Filter and manually moving/copying the info?

[NBVC]

Can you post a sample workbook with same organization but fake names and data...

[keithfender]

This sounds like a VLookUp if I understand it right.

You could have a separate spreadsheet for each of the 3 managers, and have a Vertical LookUp table for your 5 columns of info.

I'm curious to see the sampole data as well.

[Burton]

I thought vlookup originally, but I have been unable to make it work since several employees have the same manager. Vlookup keeps pulling one employee and then keeps pulling the same one over and over. I just can't seem to get it right....

Here's a mock list. My goal is to have Excel automatically fill out the 3 worksheets using the data in the Master worksheet.

[NBVC]

See attached:

Formula in D1 of each sheet counts number of employees per Manager.

Please Login or Register  to view this content.

Formula in B3 extracts employees of that manager...

Please Login or Register  to view this content.

this formula is confirmed with CTRL+SHIFT+ENTER not just ENTER and then copied down.

Formula in C3 to F3 extracts remaining info...So in C3:

Please Login or Register  to view this content.

Normally entered with ENTER and copied down and across.

these formulas are copied down to row 100.. you can extend if desired.

[Burton]

YEEEESSSSS!!! Thank you, thank you, thank you!!! I can now sleep at night You are awesome, thanks so much for the assist!