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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top