making changes to copied cell appear in original cell/

[gmp]

I would like the changes made to copied cells appear in the original
cells from where they came. I started w/ a large worksheet and broke
it into smaller ones, organized by category. Now I want the changes
made on the copied cells to occur on the original worksheet. How can I
make this happen? Thanks!

 

[Anon]

I would like the changes made to copied cells appear in the original
cells from where they came. I started w/ a large worksheet and broke
it into smaller ones, organized by category. Now I want the changes
made on the copied cells to occur on the original worksheet. How can I
make this happen? Thanks!

From where you are now, it sounds as though you will have to do this
manually. Once you have copied and pasted cells, the 'originals' and the
'copies' are independent of each other. They happen to contain the same data
or formulas, but there's no connection between them just because of their
common history.

If you want to set things up so that a cell always stays the same as
another, do not copy/paste. Instead, put a formula in the cell where you
want the 'copy' refering to the 'original'. For example, if the original was
A1 and you want G6 to always be the same as A1, in G6 put the formula =A1 .