I have a couple of problems.
If I try to copy a formula from one workbook to another new one to use the
formula in the new one it adds the name of the originating spreadsheet as
reference. I have to go through each formula and delete the name reference to
the original spreadsheet. How do I prevent that?
Next problem; when copying a workskeet that contains cell formating, color
etc how to I copy the values and formatting but not the formulas?