The cheat's way would be to use [Ctrl]+"¬" to display the actual
formulae.
Copy the formulae to the new sheet and then use Find & Replace to edit
the reference prefixing each one with the sheet reference.

eg =A1 would become =Sheet1!A1

To switch Excel back to normal mode, use [Ctrl]+"¬" again.


--
MartinShort

Software Tester
------------------------------------------------------------------------
MartinShort's Profile: http://www.excelforum.com/member.php...o&userid=22034
View this thread: http://www.excelforum.com/showthread...hreadid=548623