I have a worksheet which when I have a duplicate entry, I cut and paste the needed information to the original. However, when I do this, the formula of the orginal then changes and has #ref in it. How do I prevent this?
Also, is there a way that I could use a macro to then go to the item I just copied and paste and delete that row.

Any help would be great.