Your OP stated a single formula.

To copy en-masse, you could "unformulate" all the formulas in a selection,
reverting them to simple text, then copy that selection to the target sheet,
and then change them back to XL recognizable formulas, where they'll retain
all their original cell references.

Since the equal sign ( = ) denotes a formula, select all the formulas that
you wish to copy, then:

<Edit <Replace
In "Find What", enter
=
In "Replace With", enter
^^
And Click on "Replace All".

Then, while the cells are *still* selected,
Right click in the selection and choose "Copy".
Navigate to the target sheet and paste wherever you wish.

Now, reverse the procedure to revert the selection to formulas.

Again, while the cells are *still* selected from the Paste,
<Edit <Replace
In "Find What", enter
^^
In "Replace With", enter
=
And Click on "Replace All".

This should give you what you're looking for.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Bill Viverette" wrote in message
...
Yes, I believe that will help. I have several cells that I hoped to
cut/paste in one fell swoop, but if I can at least do one at a time that's
a
start!

Thanks,

Bill

"RagDyeR" wrote:

Open both WBs.

Select the *entire* original formula *IN THE FORMULA BAR*.
Right click in that selection and choose "Copy".

HIT <ENTER.

Navigate to the target WB, right click in the desired cell, and choose
"Paste".
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Bill Viverette" wrote in
message
...
I have two workbooks with idential worksheet names. I need to copy a
formula from a worksheet in workbook A to the same relative worksheet in
workbook B. But I want the pasted cell/worksheet references in workbook
B
to
refer to the worksheet in workbook B and not back to the worksheet in
workbook A. If I do a simple copy/paste I get references back to
worksheet
A. I see no way to do this with Paste Special. Any ideas?

Thanks in advance,

Bill