Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Consolidating data??
Hi all
I have a workbook consisting of approx. 10 worksheets, each containing details of a member of staff, ie. what qualifications they have, what jobs they can do etc. I am hoping to create a separate worksheet altogether, in the same book, that will help me 'find' people who are suited to a particular job. For example, I could somehow type 'qualification one' and it would find anybody who has qualification one. Any idea of the easiest way to do this, or even if it's possible??? Would this be easier in Access and then run Queries? Thank you. |
#2
|
|||
|
|||
Consolidating data??
Louise,
I think that Microsoft Access would be much better suited for this task. If you could put all the information about the employees on one worksheet (one row for each employee) then you could use Excel's autofilter functionality to look for employees with certain criteria. There must be some formula / macro that you could write to do what you are asking (separate worksheets) but it would make things more complicated than they have to be. Try Access if you can't get everything on the same worksheet. Bill Horton "Louise" wrote: Hi all I have a workbook consisting of approx. 10 worksheets, each containing details of a member of staff, ie. what qualifications they have, what jobs they can do etc. I am hoping to create a separate worksheet altogether, in the same book, that will help me 'find' people who are suited to a particular job. For example, I could somehow type 'qualification one' and it would find anybody who has qualification one. Any idea of the easiest way to do this, or even if it's possible??? Would this be easier in Access and then run Queries? Thank you. |
#3
|
|||
|
|||
Consolidating data??
Hi WIlliam
I had a feeling that would be the answer. This is actually for a colleaugue fo mine and for some reason, the data has to stay on separate worksheets. Thanks again. Louise "William Horton" wrote: Louise, I think that Microsoft Access would be much better suited for this task. If you could put all the information about the employees on one worksheet (one row for each employee) then you could use Excel's autofilter functionality to look for employees with certain criteria. There must be some formula / macro that you could write to do what you are asking (separate worksheets) but it would make things more complicated than they have to be. Try Access if you can't get everything on the same worksheet. Bill Horton "Louise" wrote: Hi all I have a workbook consisting of approx. 10 worksheets, each containing details of a member of staff, ie. what qualifications they have, what jobs they can do etc. I am hoping to create a separate worksheet altogether, in the same book, that will help me 'find' people who are suited to a particular job. For example, I could somehow type 'qualification one' and it would find anybody who has qualification one. Any idea of the easiest way to do this, or even if it's possible??? Would this be easier in Access and then run Queries? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
How do I import formmail data to a custom excel template? | Excel Worksheet Functions | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |