The code is actually in the workbook, Shane. Open it up and then look at the VBA code—if you don't know how, ask and any one of us will be able to explain it—and you can see how it works.

Then again, if you don't know how, maybe you've never written a VBA macro and you won't see how it works, in which case you're starting from further back than I suspected. If so, we should settle down and discuss the program a piece at a time.