Create Dynamic Data Validation List based upon Criteria

Hi Everyone -

I am trying to create a pull down data validation list to only include a list of names that meet certain criteria.

My attached workbook has 3 tabs, Employees, Salaried, and Hourly. I have a seperate validation pull down list in column A on the Salaried and Hourly tabs. What I am looking for is to build a dynamic list of names that meet 2 criteria. On the Salaried tab list, it would only include a list of Employees that are "Salaried" and "Active". Similar list for Hourly tab.

Both list will need to dynamically "grow" as new employees are added to the Employee tab.

Any help is greatly appreciated.

Thanks,
Jim

Thanks micope21.

I understand what you were doing and it does work. I think I did not explain what my ultimate goal was.

I need to end up with 2 named "lists", one the list of active salaried names, second the list of active hourly names.

See the "Goal" tab on the new attachment.

Thanks,
Jim

Thanks Benishiryo

That did work. However, the whole solution is getting too complicated. I attached a revised file.

I created a Table named "Employees" so it can grow as new names are entered. I need to work with the actual entries in Column A rater than refer to a Range, such as "A2:A25" since I do not want to come back and change the Range value if the list grows beyond "A25".

Hope this makes more sense.

Thanks to any and all who might reply!

Jim

Hello Jim
In the attachment I've added 4 columns to your Employees Table (hidden). These columns contain formulas which create the names for the dynamic ranges from which the Data Validation dropdowns work. As they are part of the Table the columns with their formulas expand as new names are added or edited. Is this something you could work with?

Hope this helps
DBY

Thanks DBY. I'll give it a try