Combining Defined Names to New Name For Validation

T

TheSpankster22

Hi,

I have two separate defined names (lists) in my worksheet:

Project_Managers_Employees
Project_Managers_Contractors

I want to create a new name (list) that is made up of the two name
(lists) above. This name (list) would be:

Project_Managers_All

This would then allow me on another sheet to use the data validatio
function to create a drop-down list with all project managers liste
without having to create a whole new list of all the project managers.

PLEASE HELP. I need an immediate solution.

Thanks,
TheSpankster2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possible to Combine reports to's to a single box? 0
Duplicate hashtags in OneNote 0
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Formatted cell column in drop down list 1
Data Validation List Names 2
Dynamic Named Ranges 3
COUNTIF and Data Validation 0

Top