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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Sheet Summary 1
Weekly Time Sheet Summary 2
Weekly Time Sheet Consolidate 1
Adding data from multiple cell and linking to a new worksheet 3
link 1 sheet to another(totals) 1
have cell in sheet 1 look up last row of column 'x' in sheet 2 4
SumIF to summarize amount in different sheets by date 4
count how many different numbers in the column and return to the n 2

Back
Top