Hi and welcome
in the future, please wrap your code with code tags (the #button)
If you are after a VBA solution please post in the correct sub-forum ( I will move it for you)
Thanks


BTW posting a sheet is better than a picture, which is nice to look at but worthless to work on

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post