Quote Originally Posted by ChemistB View Post
Are we talking about manual changes or changes due to formulas? (for example in B7 is a formula = C1+D1 and someone changes D1 which causes B7 value to change)?
Oh I see what you mean. If there are two cells within a column that may have a formula that reference the same cell and both change at once.... I see... I do not think this will be the case. I am having drop down lists for several columns with no formulas as far as I am envisioning.... The end user, or anyone for that matter, cannot simultaneously click and select multiple dropdown list items unless I've mistaken.