Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a workbook with several sheets. I have dates on the sheets that i update to same value daily.

eg. on sheet 1, the date is in cell A1, on sheet 2, the date is in cell C2, does not follow a particular order but i update them to same value daily.

Is there anyway i can link the cells, so any change made in one affects the rest?

share|improve this question
add comment

3 Answers

up vote 1 down vote accepted

on Sheet2 set the formula for C1 to:

=Sheet1!A1

rinse and repeat for the other sheets.

edit- other option would be to make cell Sheet1!A1 a named range, and then in the other cells use:

=NamedRange

to define a named range in Excel-2007 select the cell you want to name, go to the Formulas tab and click on Define Name. Enter the desired name and press OK.

share|improve this answer
add comment

Excel can do it for you automatically:

  1. click Sheet2, click C2
  2. press '='
  3. click Sheet1, click A1
  4. press Enter

Done.

share|improve this answer
add comment

You can also concantenate the cells and this will update it, just go to cell C2 and click FX find formula concantenate and click back to A1 and just do that with all the tabs

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.