Sheets are absolute, I would personally just do a search and replace and
replace the sheet names. Here's a link to a UDF by John Walkenbach

http://www.j-walk.com/ss/excel/tips/tip63.htm


Regards,

Peo Sjoblom

"AuMiQuinn" wrote:

As if that wasn't confusing enough...

Sheet 2 has a value in A15 which it's reading from Sheet 1's A15. How do I
copy Sheet 2 to a new sheet 3 so that Sheet 3's A15 points to Sheet 2's A15
and not Sheet 1's? How do I make the "=+Sheet1!A15" a relative value?