I have to cut & paste certain sheets in my project - certain sheets have formulas and these have PATH information after the copy operation along with the original formula
What starts out simply as
=IF('Input Page'!B$86="Yes",0,('Input Page'!B$87*'Input Page'!B$38+'Input Page'!B$88*'Input Page'!B$39+'Input Page'!B$89*'Input Page'!B$40+'Input Page'!B$90*'Sheet Metal Input Page'!B$47+'Input Page'!B$91)/E104)
before the copy, ends up as
=IF('C:\test updater - 7-28-2011\updates\[newfile.xls]Input Page'!B$86="Yes",'C:\test updater - 7-28-2011\updates\[newfile.xls]Input Page'!E$36/E107,'C:\test updater - 7-28-2011\updates\[newfile.xls]Input Page'!B$70/'C:\test updater - 7-28-2011\updates\[newfile.xls]Multi Use Items'!E107)
after the copy.
The code to copy a sheet from one file into the other is
What options can I use to NOT get all that PATH information stuffed into my formula?
(I still need the formulas, just without all that PATH information)
Thanks,
Bookmarks