linking data in sheets

S

sharon c

I have a daily staffing sheet for a two week period. I
want to link the rows that show total amounts (I have
formulas in them which adds several rows and then gives
total) to another sheet that will transfer the Total
amounts. As these amounts may change, I am not sure if
the changes can be carried/linked. Can anyone help?
 
K

Ken Wright

If you link the existing totals, then any changes to those rows as a result of
inertion/deletion of lines will automatically see any links in any formulas that
refer to those rows, updated automatically.

Another option is to name the cells you are linking and then use the names in
your formulas instead of range references.
 
Top