cut and paste over referenced cells

[humboldtguy]

i use my workbook in a dispatch office, we copy and paste constantly, when a customer calls in we enter the information, then we move that information to the correct time slot, copy and paste works fine, but there is the extra step of going back and deleting the original, if i could cut and paste it would save that extra step about 40 times a day...is there any way for cut and paste not to affect the formula's referring to the cell's being pasted over?

[Leith Ross]

Hello humboldtguy,

You will get more responses if you post a copy of your workbook in Excel 2003 format as well as 2007.

Sincerely,
Leith Ross