Auto Sort Macro Based on Two Columns

Hear me out. I spent the better part of my day trying to figure out how to get the all the different variations of the possible solution in question. On this site and others. My brain is basically mush at this point. For some reason I can not get the macro to work on it's own. I would tell you which macro I used but it must have been close to 10 different kinds. The only one I was able to get working, you needed to hit play in order to get it to sort.

Basically I was looking to have the data in tab "programmer 01" column K automatically sort based on its value as soon as a value is entered in column J. Column J is the input for a vlookup in column K. After it sorts on K I need it to then sort on column A. And of course the the hope is I can get this sort as soon as a value is entered in J.

I've attached a sample of the sheet. Hope someone can help me because I'm stumped atm.