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