Hello,
Can anyone help with this scenario:
Sheet 1 CellA1 has a value of 10 and CellA2 has a value of 3
Sheet 2 CellA1 has the calculation: =Sheet1A1*Sheet1A3
I would like to move Sheet 2 to a separate document and break the links to Sheet 1, but showing the formula in the formula ribbon as =10*3 and not the calculated value 30.
I have multiple cells with these links to different sheets and calculations and will not be able to use F9 function to manually change the link to a value. I would prefer not to use a macro.
Thank you for your help.
Bookmarks