"AmandaA" wrote:
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?

Please provide some details. For example:
1. The cell name of original formula.
2. The original formula.
3. The cell name where your are pasting the formula.
4. The precise keystrokes to accomplish the "cut and paste".
5. The contents as they appear in both the original cell (#1)
and the new cell (#3).
6. Are either or both the original cell (#1) or the new cell (#2)
part of a table?

In addition, it might help if you provided the URL of an example Excel file
that you uploaded to a file-sharing website. ExcelBanter might provide a
mechanism for doing this. Alternatively, use one of the following free
file-sharing websites or your own.

Box.Net: http://www.box.net/files
Windows Live Skydrive: http://skydrive.live.com
MediaFi http://www.mediafire.com
FileFactory: http://www.filefactory.com
FileSavr: http://www.filesavr.com
RapidSha http://www.rapidshare.com

Normally, __cut__ and paste does not alter the formula.

But below, you use the term __copy__ and paste. Which one are you doing?


"AmandaA" wrote:
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.

Yes; it is called an event macro.

But before we complicate things any more, I suggest that you clarify what
you are doing per above and resolve the #REF error.


"AmandaA" wrote later in response to GS's
question about copy-and-paste-special-value:
Yes I have although at times, it looses the formating of the
cells which it is going too. It also leaves the values at
the cells I moving.

Copy-and-paste-special-value per se never copies the format. You might use
paste-special-value-and-number-formats. But as the name implies, that does
not copy __all__ formatting information; for example, not Conditional
Formatting.

Also, does the original cell have values, as you say here, or formulas, as
you said initially?

Normally, paste-special-value does not alter the original cell. In
particular, it would not change formulas to values in the __original__ cell.