Data Validation

[tinie85]

I am trying to combine two separate source lists together so that when you click on the drop down they show as one list to choose from. I have a list of names in column A on SSLFirst and a list of names in column A on AuxFirst. Id like to be able to create a drop down that pulls all the names from both.

[dflak]

The attached workbook is set up to set the validation in Cell E2. This is determined by the code on Sheet 1 in the Selection_Change event. When you enter cell E2, this code is run and it calls the code in the modules to make the dropdown list for validation.

Please Login or Register  to view this content.

Put this code on whatever sheet has the dropdown box for the validation and change "E2" to the cell you want.

Put the following code in a module. List_1 and List_2 are named ranges containing the two lists. I suggest you give your lists names and use them in the code in the place indicated.

Please Login or Register  to view this content.