Oct 17 2023 05:34 PM
Oct 18 2023 12:33 AM
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 |