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
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies