Revision history [back]

How to NOT reference cells from another sheet when pasting into a new sheet

Hi

When I copy cell forumula from one sheet into another, it references the sheet it came from, which screw up my calculations.

eg copying C720.4 from the sheet Sep 17 into cell C66 in the sheet Oct 17 ends up pasting =$'Sep 17'.$C660.4 in cell C66, when all I want is C66*0.4

I have been working around it from finding and replacing "$'Sep 17'.$" with "", but it's slow when doing this multiple times over multiple sheets.

Is there are way to copy things over without the sheet reference?

Thanks for your time and help.

How to NOT reference cells from another sheet when pasting into a new sheet

Hi

When I copy cell forumula from one sheet into another, it references the sheet it came from, which screw screws up my calculations.

eg copying C720.4 from the sheet Sep 17 into cell C66 in the sheet Oct 17 ends up pasting =$'Sep 17'.$C660.4 in cell C66, when all I want is C66*0.4

I have been working around it from finding and replacing "$'Sep 17'.$" with "", but it's slow when doing this multiple times over multiple sheets.

Is there are way to copy things over without the sheet reference?

Thanks for your time and help.

How to NOT reference cells from another sheet when pasting into a new sheet

Hi

When I copy cell forumula from one sheet into another, it references the sheet it came from, which screws up my calculations.

eg copying C720.4 C72x0.4 from the sheet Sep 17 into cell C66 in the sheet Oct 17 ends up pasting =$'Sep 17'.$C660.4 17'.$C66x0.4 in cell C66, when all I want is C66*0.4C66x0.4 (the x's are actually asterisks, but the forum won't let me add them to the post). I have been working around it from finding and replacing "$'Sep 17'.$" with "", but it's slow when doing this multiple times over multiple sheets. Is there are way to copy things over without the sheet reference? Thanks for your time and help. How to NOT reference cells from another sheet when pasting into a new sheet Hi When I copy cell forumula from one sheet into another, it references the sheet it came from, which screws up my calculations. eg copying C72x0.4 from the sheet Sep 17 into cell C66 in the sheet Oct 17 ends up pasting =$'Sep 17'.$C66x0.4 in cell C66, when all I want is C66x0.4 (the x's are actually asterisks, but the forum won't let me add them to the post). I have been working around it from by finding and replacing "$'Sep 17'.$" with "", but it's slow when doing this multiple times over multiple sheets. Is there are way to copy things over without the sheet reference? Thanks for your time and help. How to NOT reference cells from another sheet when pasting into a new sheet Hi When I copy cell forumula from one sheet into another, it references the sheet it came from, which screws up my calculations. eg copying C72x0.4 from the sheet Sep 17 into cell C66 in the sheet Oct 17 ends up pasting =$'Sep 17'.$C66x0.4 in cell C66, when all I want is C66x0.4 (the x's are actually asterisks, but the forum won't let me add them to the post). 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 are a way to copy things over without the sheet reference? Thanks for your time and help.  6 None Jim K 2785 ●5 ●22 ●44 How to NOT reference cells from another sheet when pasting into a new sheet Hi When I copy a cell forumula formula from one sheet into another, it references the sheet it came from, which screws up my calculations. eg E.g. copying C72x0.4 C72*0.4 from the sheet Sep 17 "Sep 17" into cell C66 in the sheet Oct 17 "Oct 17" ends up pasting =$'Sep 17'.$C66x0.4 17'.$C66*0.4 in cell C66, when all I want is C66x0.4 (the x's are actually asterisks, but the forum won't let me add them to the post).C66*0.4.

I have been working around it by finding and replacing "$'Sep 17'.$" $'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.