A few weeks ago, when I was talking about switching the locations of two sets of cells, I mentioned the importance of using cut instead of copy, because unless you specified otherwise references in spreadsheets are relative.