May 23 2023 02:27 PM
May 23 2023 02:39 PM
You'd have to change
RIGHT('124F'!J17,1)="H"
to
RIGHT('124F'!J17,2)="SL"
and similar for the other conditions.
May 23 2023 03:07 PM
May 23 2023 03:09 PM
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.
May 23 2023 03:16 PM