After looking at what you've done here, I think the VBA might be a little too complicated for you at this point. No disrespect intended. Rather than spending time writing stuff that isn't exactly what you're looking for...why don't you just send me your database and tell me what you want done? I'll adjust the code to meet your needs and post it (the code) here publicly with the hope that others might find it useful.

Feel free to remove or alter the data if it's confidential. Just leave me a few representative samples with which to work. If you don't want to post it publicly, send me an instant message and I'll give you an email or messenger address.

FYI...considering the difference in our time zones, I don't think I'll be able to return it to you until this weekend.