Moving data between sheets

[PeterE]

I have a workbook with 20+ sheets.

Each sheet has data in some cells and formulae in other that perform calculations based on the data cells.

If cut and paste data from one sheet to another, the formulae are then corrupted as they refer to the other sheet.

Is there any way that I can get formulae to refer only to the data actually on the sheet, regardless of whether it was typed there or cut and pasted from another sheet?

 

[Grunter70]

Try using "Copy" and Paste instead of "Cut" and Paste. - Even if you then have to go back and delete the data from wherever you Cut/Copied it from.

By using "Cut" you are telling the formulae that you want them to follow the data to its new home.

 

[PeterE]

Yes, I know that works OK, but cut & paste is intuitive and it is easy to forget!