Hi, Blue. I'm not surprised no one's responded to this yet; mostly this forum is about helping each other with smaller and more specific question. For example, if you'd written a VBA program to do all that and you were having trouble getting the button to run the program, that would probably get a response. Or if your program were abending at a particular place with a particular message. But starting from nothing and hoping someone can just tell you how to jump ahead to a full solution...nah, that probably isn't going to generate much help.


If you have no VBA skills, it seems to me what you need is to gain some VBA skills. It'll take some time—like taking a class, and learning the principles a piece at a time—but of course the advantage is that before you're through you can write not just this solution but many others as well. Interested in learning how?