linking data in sheets

  • Thread starter Thread starter sharon c
  • Start date Start date
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?
 
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.
 
Back
Top