I do believe the magic you seek is actually part of the paste tool. If you
do a right-click, "paste special"-one of the options should be formulas.
They should automagically reference the new sheet, not a reference to the
copied sheet.

-Denny
--=20
http://www.piclist.com/techref/piclist PIC/SX FAQ & list archive
View/change your membership options at
http://mailman.mit.edu/mailman/listinfo/piclist
.