In the sample workbook, cells C14 through C17 are data entry fields for Customer info. Cells F14 through F17 are data entry fields for Delivery Location info. Since 95% of the time this info is the same, I put a drop down list in F11 that answers the question "Is the info the same?" If the answer is Yes, formulas in cells F14 through F16 copy the data from cells C14 through C16 to save time and work. If the answer is No, the user simply types the different info in cells F14 through F16, which over writes the formulas. That all works fine. The problem arises when trying to put the formula in cell F17 because it has the telephone number format from "Format Cells" and a 10 digit restriction in "Data Validation". Because of this formatting, excel will not allow the formula to be entered into cell F17.