Help with Copy/Paste between Workbooks and Cell/Worksheet referenc

Giganews Newsgroups
Subject: Help with Copy/Paste between Workbooks and Cell/Worksheet referenc
Posted by:  Bill Viverette
Date: Wed, 14 Jun 2006

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

Replies