Hi Everyone,

I'm a novice excel user and I've been searching around the forum the last few days trying to resolve an issue with a template i'm building.

The template will be utilized by Project Managers to track deliverables based on the phase of the project.

I have 2 sheets - 'Master' and 'Checklist'. 'Master' will be built out to include all deliverable separated by phase. This sheet will eventually be hidden / locked. 'Checklist' has two drop down lists that I would like to pull data from the 'Master' sheet. IE - If 'Initiation' is selected in B7 within the 'Checklist' sheet, I want row 11 down to populate with all tasks in sheet 'Master' B5:518 (tasks that fall within the Initiation phase).

I need the same scenario above to work with the second drop down (B8) that I would like to do the same with the other set of data

Is this possible? I've attached the document for reference. ProjectChecklistHelp.xlsx