Can this be done with Excel ?
I have a employee job scheduling table that I would like to populate
based on criteria from 2 other tables. The scheduling table has the employee names listed in each row and across the top is the period of the day broken into 4 time periods. The critera tables a 1. A training matrix that lists the employee names in each row and the jobs listed across the top. If an employee is trained, the intersecting cell has a "T". If they are not trained, the cell is blank. 2. An attendance table that lists the employee names in each row and if they are absent, there is an "A" in the next cell. If they are at work, the cell is blank. I'd like to be able to populate the scheduling table based on whether they are trained and present at work. Can this be setup in excel ? Thanks Jeff |
Can this be done with Excel ?
On Oct 13, 9:02 am, "Don Guillett" wrote:
Depending on the layout you could probably just use datafilterautofilter -- Don Guillett Microsoft MVP Excel SalesAid Software om wrote in message oups.com... I have a employee job scheduling table that I would like to populate based on criteria from 2 other tables. The scheduling table has the employee names listed in each row and across the top is the period of the day broken into 4 time periods. The critera tables a 1. A training matrix that lists the employee names in each row and the jobs listed across the top. If an employee is trained, the intersecting cell has a "T". If they are not trained, the cell is blank. 2. An attendance table that lists the employee names in each row and if they are absent, there is an "A" in the next cell. If they are at work, the cell is blank. I'd like to be able to populate the scheduling table based on whether they are trained and present at work. Can this be setup in excel ? Thanks Jeff- Hide quoted text - - Show quoted text - I'm not I understand how to do this with AutoFilter. Could you explain ? Thanks |
All times are GMT +1. The time now is 03:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com