Thanks for your suggestion guys. This was an exam for a job I really needed. They only gave me 24 hours to do it, and I had no VBA experience. I'm in accounting-we don't usually do VBA, unless it's in excel... I ended up hiring someone from one of the forums to do it for me. Thanks for your suggestions.