3 years later, I've found this through googling how to copy a lot of cells and keep the references. So simple but effective, I love the find & replace with # and =...so often in excel we get tied up trying to overthink things.
It worked nice, but what if I need to paste the Formulas on another sheet and keeping the references to the previous sheet? basically the same but on another sheet
This is what I'm looking for as well. Copy formulas to another sheet without breaking formulas - and still referencing old sheet. I guess could copy sheet name but tedious to past before each cell name.
what I'm looking for is to copy the cell data from one cell to another without coping the formula in that cell, when I try the whole thing copies formula and all I need the formula to stay in the one cell.