View Single Post
 
Old 03-21-2018, 12:43 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

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.
Attached Files
File Type: xlsx sample.xlsx (306.0 KB, 10 views)
Reply With Quote