Hello, I have a situation where I want to move 3 sheets from one workbook to another. The Problem is that the sheets appears to carry their File Path with them creating a Problem for my formulas within the destination sheet..

Is there a way to keep the Formulas in tact to represent the destination sheet?

The Workbooks have the same Data, but 3 sheets from the source workbook need to be inserted in the destination workbook without paths in the formulas leading back to the source workbook (file).

eg.

Source workbook sheet1 A1 Reads:

=IF(DAY14!B33>0,DAY14!C33,"")

When it is copied to the Destination Worksheet it Reads:

=IF('[JULY CALLS CREATION BU9 TESTING.xls]DAY14!B33>0,'[JULY CALLS CREATION BU9 TESTING.xls]DAY14!C33,"")

I modified the above formula slightly to remove the Reference errors, but I just want to show basically what is happening...

Thanks for any help here...