I would like to insert in a cell the value calculated by a formula in another sheet.
If I use the something like =MySheet!MyCell
Excel adds a reference to that cell and by doing that it actually re-use that formula.
As only option I know I can use "Paste Value" to copy the value from that source cell to my destination cell.
Is there any Excel function to just copy the value or do I have to implement a function/marco myself?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…