No need for code! Look at updated workbook in attachment!
Update: Btw, you can use tMal as list of persons. I.e. instead of separate table tPersons on sheet Persons, you can define name lPersons = tMal[Paratrooper], and remove data validation from column Paratrooper.
|