Thanks again. These helped greatly. It's a ridiculous worksheet that I've used for the past 4 years and had to manually change the formulas when necessary because I never had the time to sit down and work on it in the past. This just made everything a whole lot easier and solved the problem of the wrong quotes being given when I'm out of the office because other's didn't remember the exceptions to the rules.