http://www.gfcproducts.com/LatheSchedule-master.xls
What I need to be able to do is some kind of dynamic filter, where I can EASILY pick the following fields of interest: EMPLOYEE and JOB-SO.
I want to be able to view what each employee is doing all week. The main reason is to make sure that one employee is not being scheduled on too many machines, (which they are usually scheduled on more than one machine a day) or too many times of the week.
The auto filter only works for one day of the week, but I would like to view what one employee is doing all week.
If you add peoples names in the fields, you will see what I mean.
If using a dynamic filter, I would like to see the employees in a drop down box, and it filters out all the other people that I did not pick, and same with the SO-JOB’s.
with this version, I would need to filter the machines, and the JOB-SO. Again, they would need to be filtered for the whole week so I can see that there are not more than one person running the same machine on the same day.
If you see that there may be a easier, more readable way of setting up this form, that would be great if I got your input.
WORKING WITH EXCEL 2003
What I need to be able to do is some kind of dynamic filter, where I can EASILY pick the following fields of interest: EMPLOYEE and JOB-SO.
I want to be able to view what each employee is doing all week. The main reason is to make sure that one employee is not being scheduled on too many machines, (which they are usually scheduled on more than one machine a day) or too many times of the week.
The auto filter only works for one day of the week, but I would like to view what one employee is doing all week.
If you add peoples names in the fields, you will see what I mean.
If using a dynamic filter, I would like to see the employees in a drop down box, and it filters out all the other people that I did not pick, and same with the SO-JOB’s.
- The Employees at one point will be changed, and I will have to add or remove employees, but the JOB-SO is something that changes every day. I am adding new jobs every day, and also taking away jobs from the data sheet. ( I hope this won’t affect the dynamic filter )
with this version, I would need to filter the machines, and the JOB-SO. Again, they would need to be filtered for the whole week so I can see that there are not more than one person running the same machine on the same day.
If you see that there may be a easier, more readable way of setting up this form, that would be great if I got your input.
WORKING WITH EXCEL 2003
Last edited: