Hi Frank ,
Your explanation is detailed , but the application is more complicated than your explanation reveals.
Can you upload a sample workbook , with say 10 to 20 rows of data , consisting of enough IDs using the TSK prefix , and enough IDs using the ISS prefix.
Also explain with at least 2 examples , what would happen if any Task were to be changed to Issue , and the other way round.
Just as an example , suppose the entries were as follows :
TSK-001
TSK-002
ISS-001
TSK-003
ISS-002
ISS-003
TSK-004
Is this a valid illustration of the way entries will be present ?
If so , what would happen if the entry TSK-003 were to be changed to Issue ?
Thereafter , suppose the entry TSK-002 were to be changed to Issue , what would be the result ?
Narayan