Hi all,

I am struggling to wrap my head around the formulas for a form template.

Ideally the user selects a project number from a dropdown list, in another cell the sections that correspond to the selected project number are shown in a second dropdown list. Now there are 6 slots for tasks which should also be dropdown lists that correspond to the section selected. For each task there is a code assigned and the code should auto populate in the cell directly below the corresponding task. The issue I am having is each project number has it's own worksheet containing the sections, tasks, and codes.

The Form is its own sheet separate from the information sheets.

Please help,

K