Hi Guys,
I've looked through the threads to find a solution to my query, but I can't find anything that matches what I want to do without making significant changes.

I have a spread sheet that has three sheets, PROJECTS - TIMES - LISTS
Time sheet.xlsx
PROJECTS contains a list of 'In Progress' and 'completed' projects for work, with relevant other data, I.e. PROJECT No. / STATUS etc This will grow to 1,000's of rows
TIMES will contain the amount of time a person spends on a PROJECT on a daily basis. This will grow to 10,000's of rows
LISTS contain basic validation list for the first 2 sheets.

Part A
I would like to have a validation drop down list for the PROJECT NO column in the TIMES sheet that only lists the PROJECT NO from the PROJECTS sheet where STATUS <> COMPLETED.
I.e. I only want to display the PROJECT NO's for current projects.

Part B
Even though I only want the PROJECT NO used, can the drop down list also contain other column's data for reference information only before one is selected.

Thank you.