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

A

arttrust

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
 
T

Toppers

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
 
Top