Hi,
Well I must admit I'm stumped
I can see you posted your original question in the Programming Forum and now that I've seen your spreadsheet that's the best place for it. When I first saw your original question I throught I could do it with formulas.
I suggest that you post again in programming, but under a new title and attaching your last spreadsheet, but you could also provide a link to this thread as well so that they can see not to do anything like I did.
Sorry I can't help, only VBA is not my expertise - good luck
Bookmarks