On 4 September 2014 01:54, Justin Richards <justin.richards@gmail.com>
wrote:

> Not sure exactly what you mean so I have experimented
>
> I named cells A1 B1 C1 to SUM1, SUM2, SUM3
> the referring to them  in D1 =3D SUM1 + SUM2 + SUM3
> D1 then sums whatever is in A1,B1,C1
> I then copy the entire sheet1 and pasted to sheet3 in the same workbook a=
nd
> they do not seem to refer back to sheet1.
>
> 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?


           Russell
--=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
.