J
John
I want to create a form for a multi location employee Holiday request.
Within this file will contain all data concerning employees holiday
allowances for the whole company.
I wish the user on selecting their 'location' in a particular cell (via drop
down list) to only see those employees that work in that location. My data
will be arranged as follows: Employee Number (Column A); Employee Name
(Column B); Location (Column C).
On the user input form, the Manager would select his/her location in Cell
A1, then in cell A7 they would select the Employee (from a drop down list)
that they wish to request holidays for.
I can't figure out how I can get my data (over 3000 employees across all
locations) to limit in a 'drop down list' to just the location that was
selected in A1. Do I use some form of Advanced Filter? Are there any good
web sites that can detail examples?
Thanks
Within this file will contain all data concerning employees holiday
allowances for the whole company.
I wish the user on selecting their 'location' in a particular cell (via drop
down list) to only see those employees that work in that location. My data
will be arranged as follows: Employee Number (Column A); Employee Name
(Column B); Location (Column C).
On the user input form, the Manager would select his/her location in Cell
A1, then in cell A7 they would select the Employee (from a drop down list)
that they wish to request holidays for.
I can't figure out how I can get my data (over 3000 employees across all
locations) to limit in a 'drop down list' to just the location that was
selected in A1. Do I use some form of Advanced Filter? Are there any good
web sites that can detail examples?
Thanks