Can I sync information on one worksheet with another worksheet
 

There are 4 sheets. One is a main worksheet that is a combination of the
other 3. Can I link data from any of those sheets so when you change any data
it will update in the main worksheet?

The short answer is: Yes, you can

The long answer is: Providing a little more description about what you want
to accomplish will lead to much more concise advice from the people here.

For instance:
Are you 3 detail sheets identical?
Will the summary sheet just be the sum of the individual sheets, or do you
wnat to show the values from all the sheets separately?

Inquiring minds want to know!

"Eileen" wrote:

There are 4 sheets. One is a main worksheet that is a combination of the
other 3. Can I link data from any of those sheets so when you change any data
it will update in the main worksheet?

The three sheets are each different. Example #1 sheet has the figures for
current projects, #2 has the following years projects # 3 has the future
projects. All have the amounts that for that certain year. The main "huge"
worksheet would have all of the 3 other sheets information.
What I need to know is, if for example, I change the amount budgeted for
Toilets on sheet #1, that on the "huge" sheet it also changes. That way I
don't have to find that entry on the "huge" sheet and manually make the
change.

Hope that is a little more specific. Let me know if anyone has any ideas.
Also, Thanks Drew for the info.


"Duke Carey" wrote:

The short answer is: Yes, you can

The long answer is: Providing a little more description about what you want
to accomplish will lead to much more concise advice from the people here.

For instance:
Are you 3 detail sheets identical?
Will the summary sheet just be the sum of the individual sheets, or do you
wnat to show the values from all the sheets separately?

Inquiring minds want to know!

"Eileen" wrote:

There are 4 sheets. One is a main worksheet that is a combination of the
other 3. Can I link data from any of those sheets so when you change any data
it will update in the main worksheet?