I did not thoroughly test this.  When retesting I copy to the new sheet the
cell names disappear. :(

Excel 2003


> > That is exactly what I want.
> But, if I name the cells using 'Insert Name Define' it does not (
> for me) work as you describe.
> The total in D1 always refers to the original sheet
>
> What version of Excel are you using?
>
--=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
.