I
I
I regret having to say that I didn't get to your question but here is what I have done.
After reviewing about 20% down your code I ran into trouble. It seems like you forgot to turn off the recorder and continued typing. Your input is needed to delete what doesn't make sense. So I stopped my review. You will see the difference where I stopped formatting and every line is commented out.
The important thing is that you own this code. Therefore I suggest that you start at the top, as I did, and read my comments. Make sure you understand all the changes I made. There aren't many but they are cutting deep.
Then take out (delete) those lines of code which I don't know what to do with (see my comments).
Finally replace all Select statements in the unreviewed part of the code with proper addressing. You have ample examples how to do it in the part of the code where I did the job.
After you have done all that your original question will still be there but the environment will have changed. Put it into the new thread. Continue in this thread with any questions that might arise from the changes I have made. Note that I didn't test run my code. I wanted to leave some work for you lol:
BTW, I am impressed by the size of the task you have taken on and the progress you have made while working on it. Keep at it. It's turning out beautifully.