How do I connect two cells? If one cell changes the other changes
 

The first amount i s a subtotal if that changes the cell where al the
subtotals are listed...in the overview....has to change also

How do I connect two cells? If one cell changes the other changes
 

Example:

in H1:

=A1

if A1 changes, H1 changes

=Sheet1!A1

If H1 is in say Sheet2, it will change if A1 in Sheet1 changes

HTH

"arttrust" wrote:

The first amount i s a subtotal if that changes the cell where al the
subtotals are listed...in the overview....has to change also