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