extract data from worksheet
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
|