Hi, Musab. I thought I'd drop by after a while away, and I see that no one's responded to this yet. I'm guessing it's because this is a relatively complex question and no one cares to just write your program for you, since you say you're helpless in VBA.


But I would say that's where the solution lies, too: If you're helpless in VBA, then you need to get less helpless in VBA—less-helpless enough that you end up being able to write this program and understand how it works. Me, I'm no more enthusiastic about just writing it for you than anyone else. But I don't mind coaching you for a while until you're able to create the solution for yourself. Interested?