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 |
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 |
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 |
All times are GMT +1. The time now is 03:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com