Home

Can the contents of a drop down box be dependent on the answers of another drop down box

%3CLINGO-SUB%20id%3D%22lingo-sub-858782%22%20slang%3D%22en-US%22%3ECan%20the%20contents%20of%20a%20drop%20down%20box%20be%20dependent%20on%20the%20answers%20of%20another%20drop%20down%20box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-858782%22%20slang%3D%22en-US%22%3EI%20am%20working%20for%20a%20college%20and%20they%20want%20me%20to%20make%20an%20excel%20spreadsheet%20to%20help%20with%20appointment%20scheduling.%20We%20have%20three%20campuses%20and%20many%20departments.%20So%20they%20want%20a%20drop%20down%20box%20where%20you%20select%20the%20campus%2C%20then%20you%20select%20the%20department%20(%20which%20these%20will%20be%20the%20same%20on%20all%20three%20campuses)%20but%20where%20it%20changes%2C%20is%20they%20want%20a%20way%20that%20when%20you%20select%20North%20Campus%2C%20that%20the%20list%20of%20employees%20will%20change%20based%20on%20the%20campus%20selected.%20And%20from%20there%2C%20depending%20on%20the%20day%20you%20select%20for%20that%20employee%2C%20it%20will%20show%20the%20hours%20they%20work.%20Is%20this%20possible%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-858782%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-859083%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20the%20contents%20of%20a%20drop%20down%20box%20be%20dependent%20on%20the%20answers%20of%20another%20drop%20down%20box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-859083%22%20slang%3D%22en-US%22%3ESee%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.contextures.com%2Fexceldependentdropdownsetup.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.contextures.com%2Fexceldependentdropdownsetup.html%3C%2FA%3E%3C%2FLINGO-BODY%3E
Workinprogress
New Contributor
I am working for a college and they want me to make an excel spreadsheet to help with appointment scheduling. We have three campuses and many departments. So they want a drop down box where you select the campus, then you select the department ( which these will be the same on all three campuses) but where it changes, is they want a way that when you select North Campus, that the list of employees will change based on the campus selected. And from there, depending on the day you select for that employee, it will show the hours they work. Is this possible?
1 Reply