I would appreciate your help in the following issue: 3 columns with dates, 6 columns with names. Any name can be in any column J-O, any date can be in any column G-i. Even on different rows.
One name cannot be assigned a date >= 2 times (the guy can't be auditing in 2 places at the same time).
When this happens, I need highlighted the duplicate date and name.
I have included 2 images ("Registru", where I need to input the VBA code and "Registru2", where I exemplified finding the duplicates using 18 additional columns concatenating date + name).
Thank you very much,
One name cannot be assigned a date >= 2 times (the guy can't be auditing in 2 places at the same time).
When this happens, I need highlighted the duplicate date and name.
I have included 2 images ("Registru", where I need to input the VBA code and "Registru2", where I exemplified finding the duplicates using 18 additional columns concatenating date + name).
Thank you very much,
Registru.xlsm | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
G | H | I | J | K | L | M | N | O | |||
1 | ziua 1 | ziua 2 | ziua 3 | Auditor sef | Auditor 1 | Auditor 2 | Auditor 3 | Expert tehnic 1 | Expert tehnic 2 | ||
2 | 15-Jan-2023 | 16-Jan-2023 | 17-Jan-2023 | Name1 | Name3 | Name5 | Name8 | Name10 | Name15 | ||
3 | 14-Jan-2023 | 15-Jan-2023 | 16-Jan-2023 | Name2 | Name1 | Name7 | Name7 | Name11 | Name16 | ||
4 | 12-Jan-2023 | 13-Jan-2023 | 14-Jan-2023 | Name2 | Name4 | Name1 | Name12 | Name17 | |||
5 | 10-Jan-2023 | 11-Jan-2023 | 15-Jan-2023 | Name3 | Name6 | Name8 | Name13 | ||||
6 | 09-Jan-2023 | 09-Jan-2023 | 10-Jan-2023 | Name4 | Name7 | Name14 | |||||
Iesiri |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
J2:O6 | List | =Liste!$A$2:$A$16 |
Attachments
Last edited by a moderator: