Create sorted list based on longer, unsorted source

Please Login or Register  to view this content.

This part of your code is re-triggering the Workbook_Deactivate event procedure hundreds of times causing CreateTaskList1 to be called each time. Adding the Application.EnableEvents = False prevents that.

Just a thought.
Use the BudgetTaskList column on the 'List' sheet as a helper. The actual list, Task_work_List_2, could then be populated using*:

Formula:

Please Login or Register  to view this content.

*Denotes an array entered formula which is confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Note that I did not link the table on the 'Second' sheet to the new column on the 'List' sheet.
Let us know if you have any questions.

The array entered formula in column E on the list sheet has been modified to read:

Formula:

Please Login or Register  to view this content.

A list that combines tasks and descriptions, is produced in column H on the Lists sheet, using: =E4&" "&F4
The Named Range "BudgetTaskList" has been modified so that it refers to column H
If you select a drop down in column A on the Second sheet you'll see that it displays both tasks and descriptions.
Let us know if you have any questions.

I have let this sit for a few days in hopes that someone else with more experience regarding drop downs would pick this up. I am not aware of a way to do what you are asking. I wonder, however, why you would want to do this. It occurs to me that the reason might be that people would recognize the descriptions but not the tasks. If that is the case would it be acceptable to put the drop down in column F, linked to the list of descriptions in table 1, then auto fill column A using Index/Match to display the Tasks?
Let us know if you have any questions/comments.

Originally Posted by kammend

The reason I need this is that the code itself does not mean much to the user.

That is why I feel that using the descriptions as the drop down and indexing the tasks is the better option.
If you look at the attached file you'll see that a new named range is added which refers to the descriptions in table 1.
Data validation is applied to the descriptions column in table 2.
The task column is table 2 is populated using: =IFERROR(INDEX(Table1[Tasks2],MATCH([@Description],Table1[Description],0)),"")
Let us know if you have any questions.