Custom Drop Down List

Hi

I would like to know if this is possible. In the " Notes" tab for the attached file I would like to create a drop down list populating the values from the "Parts" tab .

Work ctr --- Should be populated with the unique values from Column A in the "Parts" tab

Order --- Should be populated with the values from Column F but only for the Work ctr selected before.

Any help or advise will be greatly appreciated.

Works great . But how can I add more rows

If I try dragging down or copying the row .The data for Order (Column B) is no longer populated with the corresponding information

Thank you

Any idea on how to solve the following messages ,

Removed Feature: Data validation from /x/worksheets/sheets.xml part

Its crashing when I close and reopen the file