ExcelBanter - Moving data without keeping formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Moving data without keeping formula (https://www.excelbanter.com/excel-discussion-misc-queries/199740-moving-data-without-keeping-formula.html)

Zack

Moving data without keeping formula

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?

Elisabeth D

Moving data without keeping formula

Copy -- Paste Special -- Values

"Zack" wrote:

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?

All times are GMT +1. The time now is 07:35 AM.