Forum Discussion
Excel 365 with Multiple drop-down with multiple cascading
Thanks for your support. I have multiple projects (project name) with multiple departments(differ ProjectWise), and each department have multiple Sections (listed below) and each Section have multiple Deliverables and each Deliverable have multiple tasks.
I need to do multi dependent dropdown and cascading list in Excel based on Project Name Selection, only applicable department should be listed in the next column and based on Department filter should list only the applicable Sections of that Department and based on the Selected Section applicable Deliverables should be listed in the next column and based on that Deliverable all tasks should be listed in the next column.
I also explained in the below table- please check. Further if you have any questions please get back.
Project Name 2021 S&G Project 2022 SLS Project 2023 HIA Project 2023 HIA Project (selected) Departments Administration Business Development Engineering Program Management Sections Administration Business Development Engineering Program Management Admin Sales & Marketing Design Projects Accounts Estimation & Proposals Development Procurement HR Sustainability & Growth Testing Panel Integration IT & Telecom Customer Service Stores Training Document Control Shipping & Logistics Deliverables Admin Accounts HR IT & Telecom Admin Tasks PRO Services PO's Organogram (structure) Hardware PRO Services Vehicles Insurance Reports & Meetings Vehicle Invoice Recruitment & Selection ( Contract, Job Description, Leave roaster, Induction, Training) Software CR Renewal Vehicle Selection and Purchase Employee Medical Insurance Admin Reports Insurance Payment Human Resource Planning (Timesheets, Training, Performance Appraisal) Telephone, Mobiles, SIM Baladiya Renewal Vehicles Maintenance Employee Work Insurance Reports & Meetings Banking HR Manuals (policy & Procedures) Computer Card Renewal Vehicle viloation Vechile Insurance Audit Team Building Employee new Visa Travel Insurance Yearly Budgeting Employee QID Meetings Employee QID Renewal ADLSA Labour contract Accounts Tasks PO's Invoices Payments Banking Audit Yearly Budget Reports & Meetings Receving & Reviewing Clients PO's Issuing Invoices to Client's Recevieable tracking & followup Online transfer Auditing Finance weekly Metrics review and update Issuing PO's to OEM's/Suppliers Reviewing & Checking OEM's/Supplier Invoices Payable tracking & updates Receving Cheque book Tax renweals Monthly Finance Metrics update PO's Terms & Conditions Invoice Terms & Conidtions CDC/PDC issuance tracking Conducting Department meetings Credit Buera report collection Attending Management meetings Files & Records Management HR Tasks Recruitment & Selection HR Planning HR Manuals Team Building Employment Contracts Organogram(structure) Policy & Procedures Job Description Resource Capacity Planning Induction Training Needs of Employees Training Timesheet Review and Action Performance Appraisal Employee Leave Roaster Business Trips Annual Air Tickets
