I need an Excel sheet made up with multiple dependent lists.
Basically there will be 2 sheets, a legend sheet and a data entry sheet (one for each month).
The Legend sheet will consist of 4 columns, each dependent on each other, being a list of Employee names, Their Supervisor, Location and Department.
The data entry sheet needs to work as so, I enter Employee name in first column, then click dropdown in column 2 which populates Supervisor name and so on for the other columns.
I can currently do this with 2 columns but can't work out how to do it for 4.
I have about a 40 dollar budget for this if someone can deliver me a working sheet and I can send you an example of what I'm looking for I just need someone to do the formulas etc, no data entry or anything like that.