The easiest way to avoid this is to use standardized templates so the data for that purpose is always in the same columns.



Beyond that, you could use relative references in R1C1 style rather than A1 style. That way instead of referring to cell BF7 you'd be directing it to the cell two columns to the left and no rows up or down. See also: Excel: Learn R1C1 Referencing to Understand Formula Copying - Excel Articles

Finally, I'd say find/replace would be really easy.

Ann