Hi
When I copy a cell formula from one sheet into another, it references the sheet it came from, which screws up my calculations.
E.g. copying C72*0.4
from the sheet “Sep 17” into cell C66 in the sheet “Oct 17” ends up pasting =$'Sep 17'.$C66*0.4
in cell C66, when all I want is C66*0.4
.
I have been working around it by finding and replacing $'Sep 17'.$
with “”, but it’s slow when doing this multiple times over multiple sheets.
Is there a way to copy things over without the sheet reference?
Thanks for your time and help.