Is there a way to cut and paste without getting a reference error in a fomula on another sheet. I need to link the data from one sheet to another but be cable to cut a line from one area and put it into another.