« In algebra, what is the difference between rule and roster?
How do you convert 75 degrees into a radians fraction with pi in the numerator? »

Is it possible to automatically sync the worksheets within an Excel document?

I have a spreadsheet in Excel which contains of four worksheets. One of the worksheets is a compilation of all the information in the other three sheets.

My question is: is there an option somewhere that will allow the information in the other worksheets to be automatically synced should I choose to add or update information in one of the sheets?

To link the data between worksheets you have to reference from one to the other.

So in Sheet4 A1 put
=SUM(Sheet1!A1,Sheet2!A1,Sheet3!A1)

You can drag this formula down and across to create a complete total sheet which always stays up to date.

This entry was posted on Wednesday, October 28th, 2009 at 11:28 pm and is filed under worksheets. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Is it possible to automatically sync the worksheets within an Excel document?”

  1. Andrew L Says:
    October 29th, 2009 at 5:11 am

    To link the data between worksheets you have to reference from one to the other.

    So in Sheet4 A1 put
    =SUM(Sheet1!A1,Sheet2!A1,Sheet3!A1)

    You can drag this formula down and across to create a complete total sheet which always stays up to date.
    References :

Leave a Reply