Originally Posted by BobBridges

Daymaker, you're making me just a little bit nervous. I am indeed willing to help, but how? I'm firmly against the notion of my simply writing a VBA subroutine for you. Oh, I do that sort of thing professionally, and I've no objection to doing it on that basis; but this forum isn't for that, here we tell each other how for the love of the game.

I can do that—I will—but it would be by helping you understand how to write the VBA module yourself. I don't think it would be very complicated, but you must be the one who writes it because you're the one who has to live with it afterward—explain it if necessary, fix it if the input format changes, enhance it if requested and so forth.

If that's what you meant, great! But if not, reconsider how you want to approach this, knowing that I'll explain forever but you'll have to be the one who actually puts the pieces together into a working whole.