Moving data without keeping formula

Z

Zack

Generated new columns by formulas, but now when merging with an existing
workbook, I get this #REF entry due to the fact that the formula is not
there any more. What is the solution around this hiccup?
 
Top