Lookup a value in a list & return multiple corresponding values

[medic]

I have a main worksheet that has the following columns, Dept #, First
Name, Last Name, City, Home Phone, Cell/Pager and Position. On
individual worksheets (within this workbook) I would like to display
all the information listed above, but for specific department numbers.
Like department 900 on one worksheet and 901 on another worksheet. Once
these worksheets are created I would like them to be updated when the
main worksheet is updated.

Thank you

 

[Don Guillett]

have a look at using
data>filter>autofilter>filter on the dept

 

[Biff]

Hi!

This is exaclty the same thing:

http://tinyurl.com/mvgxh

Biff