That's a watered down version of what my code does. It basically takes data from one format and converts it to another. There are a few more nested vbYesNo's to get all of the options. I'd like to be able to use one UserForm to replace all of them. It works right now, but that's because I wrote it and I'm using it. I plan on giving it to the other guys in my department, and I'd rather it be self-explanitory than have them delve through multiple queries.
I was thinking something along the lines of: