I have copied a worksheet from one workbook to another where on the worksheet I have formulas that refer to another sheet common in both workbooks..eg
Book1 sheet(MyData) sheet(MyLookUp)
Book2 sheet(MyData) copied sheet(MyLookUp) from Book1
My problem is that the copied sheet formulas still refer to Book1 sheet(MyData)
I need the copied MyLookUp formulas to now refer to exactly the same structure in Book2 sheet(MyData) eg to local sheets in the local workbook.
How do I overcome this please