Hi
If you need to keep your data on the main sheet in its original order and do
not wish to carry out a sort, then an alternative would be to select the
header row of your main sheet and use Data=Filter=Autofilter.

Select the Filter on each department in turn and the copy the visible rows
across to other sheets to achieve the same effect.

--
Regards
Roger Govier
"R.VENKATARAMAN" wrote in message
...
If I understood correctly you can sort the data on the basis of department
and copy each department peoples names into other sheets.


sallu wrote in message
...
Hi,
I have a problem with extracting data from a worksheet.
I have many worksheets in one file. There is a "Main" worksheet that
contains all the data about all employees in a cmpany. The employees are
divided into departments, so basically the "Main" worksheet has data in
the
following format: (Dept, Name)

Now I want to seperate out employees for each department, and create a
seperate worksheet for each dept. I want each department worksheet to
have
the names of people for that dept only.

Is there any way I can do that?

Salman