|
|
#5
03-21-2018, 12:43 AM
|
|||
|
|||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Referencing using a variable | Mohd_KB | Excel Programming | 1 | 03-02-2018 12:41 AM |
| Referencing different sheets | jrr95 | Excel | 1 | 03-15-2017 11:11 PM |
| Auto referencing | SharkAttack | Word | 5 | 02-17-2013 07:09 PM |
| Referencing | darksupernova | Word | 4 | 11-08-2012 03:37 AM |
| Referencing Previous Numbered List | QUL001 | Word | 0 | 03-18-2010 12:14 AM |
Windows 8 
Office 2016
Threaded Mode