N
Nimish
I am doing scheduling in excel for 2 worker types. I have a data
validation formula that pulls off a list of unscheduled employees.
This unscheduled employees list is actually created from a larger list
of all employees, and I have a formula that counts whether they have
been used or not on the daily schedule.
The flow is as follows:
Total List ---feeds---- Unscheduled List ----feeds----data validation
to select employee ---- feeds count on total list if scheduled
Basically, my data validation list restricts for some other variables
to pull names based on areas of work. The problem is that I can't
distinguish areas of work and also job type (driver or helper).
So, if my dependant validation already pulls employees who work in a
particular area, how can I restrict this to also be dependent on
whether they are a driver or helper?
Anyone have thoughts? I can send some code.
validation formula that pulls off a list of unscheduled employees.
This unscheduled employees list is actually created from a larger list
of all employees, and I have a formula that counts whether they have
been used or not on the daily schedule.
The flow is as follows:
Total List ---feeds---- Unscheduled List ----feeds----data validation
to select employee ---- feeds count on total list if scheduled
Basically, my data validation list restricts for some other variables
to pull names based on areas of work. The problem is that I can't
distinguish areas of work and also job type (driver or helper).
So, if my dependant validation already pulls employees who work in a
particular area, how can I restrict this to also be dependent on
whether they are a driver or helper?
Anyone have thoughts? I can send some code.