extract data from worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
If I understood correctly you can sort the data on the basis of department
and copy each department peoples names into other sheets.
 
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.
 
Back
Top