Creating seperate sheet lists from larger list

[macquarl]

I have a list the is in one sheet - this list contains names and departments and then the data that I seek.

Currently there are seperate lists on different "department" sheets that break down the people that are on the complete list so that department managers can click on their sheet and just view their data. This is all done manually.

The problem: With turnaround (hiring, firing, dpeartment moves, etc) these sheets are becoming a nightmare to maintain.

The question: Is there a formula that I can use that will use the main listing as a starting point that will filter the other sheets based on the department listed in column B so that column A and Column C (the data) will appear in the various department sheets?

Any help would be greatly appreciated.

[Ron de Bruin]

Hi macquarl

You can try this
http://www.rondebruin.nl/copy5.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"macquarl" <[email protected]> wrote in message
news:[email protected]...
>
> I have a list the is in one sheet - this list contains names and
> departments and then the data that I seek.
>
> Currently there are seperate lists on different "department" sheets
> that break down the people that are on the complete list so that
> department managers can click on their sheet and just view their data.
> This is all done manually.
>
> The problem: With turnaround (hiring, firing, dpeartment moves, etc)
> these sheets are becoming a nightmare to maintain.
>
> The question: Is there a formula that I can use that will use the main
> listing as a starting point that will filter the other sheets based on
> the department listed in column B so that column A and Column C (the
> data) will appear in the various department sheets?
>
> Any help would be greatly appreciated.
>
>
> --
> macquarl
> ------------------------------------------------------------------------
> macquarl's Profile: http://www.excelforum.com/member.php...o&userid=26388
> View this thread: http://www.excelforum.com/showthread...hreadid=477665
>