Dynamic Drop down list based on a column filter

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.

Hi MarvinP,

Thank you for the welcome and your reply.

There are a couple of issues with using the Advance filter.
Whilst I will have various filter options on the PROJECTS sheet, I didn't want to apply any filters on the PROJECTS sheet to use the drop down list.
I was hoping the Data Validation would handle the filtering some how. Maybe VBA???
The other thing I read earlier and just tested, is that applying filters doesn't reduce the values in the drop down list.

I'll keep looking.

Thanks again.