Sep 10 2021 07:02 AM
Do you know if it is possible to copy and paste a table with formulas, without changing the formula references (i.e. like cut and paste, without actually cutting the original table)?
Sep 10 2021 08:28 AM
Have you tried to Copy and then paste using any of the options on the Paste....Special.... Dialog box?
Sep 12 2021 04:27 AM - edited Sep 12 2021 04:28 AM
Sep 12 2021 04:27 AM - edited Sep 12 2021 04:28 AM
It is so long since I have used a relative reference that I have forgotten the behaviour (I only use arrays and lists)! I now have a feeling of shock when duplicating a formula generates different results.
A strategy of last resort might be Ctrl/H to replace equals '=' by backslash '\' and then copy the formula as dumb text. Returning the '\' to '=' reinstates the formulas as they were. A similar strategy could be to use FORMULATEXT in some scratch area and then Copy/Paste values. You could still need 'text to columns' to commit the resulting text as a formula.