This post doesn't really help your cause, Zack.

Unless you think this entire forum is set up to make fun of people who know less about VBA than the experts who post answers, or the forum was set up to tease people by knowing an answer but not giving it, your sarcasm not only doesn't help, but you contribute to the problem by posting bad information.

The above code does not do what you say it does, obviously. It is also probably not even the best way to accomplish what you would want to do.

However, it is a sample of the kind of code which would be the result of recording a macro to get you closer.

What has been said repeatedly in this thread is two things:
1) the answer is not simple because it revolves around items which can only be tested in your specific environment

2) requests for you to post a document with samples of your progress, things you've tried, etc.

For example, if you had tried to record the macro of the process Fumei had described with his 4 steps of basic logic, and then posted that recording (after cleaning it up an trying to understand it), you would be closer to your goal.

These requests have been made not because people are lazy, but because you don't have the capacity to ask the right very specific conceptual programming questions, and thus seeing an actual document/recorded macro would help give concrete information your lack of knowledge prevents you from conveying.

But there's really no need to get sarcastic with people who are, ultimately, trying to help you