Dear All,
I have a file in which there are many sheets. (e.g Sheet1, Sheet2, Sheet3).
In Sheet2, there is data which is linked to Sheet1 and Sheet3. (e.g in Sheet2, A3 = 10 + Sheet1!E10 + Sheet3!E10 ).
There are many such formulas in Sheet2.
Is there a macro which will break the link connection and return the value A3 = 10+50+60 (Sheet1!E10, Sheet3!E10).
Please assist.
Bookmarks