|re: I don't understand the code enough to recognize my errors|
...and we can't help you with the errors unless you tell us what they are.
It wouldn't make sense for us to start from scratch since there is already code available that does what you want. We just need to get it working for your specific circumstance.
Perhaps this will help. I wrote this tutorial back when I was learning VBA. The techniques described can really help you with debugging code and determining how things work and/or why they don't. I use these techniques on a daily basis, not only for my own code, but especially when I'm trying to understand how other people's code does what it does or why it doesn't do what it is supposed to.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.