Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
up vote 1 down vote accepted

on Sheet2 set the formula for C1 to:


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:


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

Excel can do it for you automatically:

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


share|improve this answer

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .