updating Excel workbook

  • Thread starter יהונתן טבת
  • Start date

×

יהונתן טבת

Hi,

I am using an Excel workbook with 10 worksheets.
Every worksheet has lists of different names and different amounts.
The tenth worksheet needs to have in it the updated summation of all nine
other worksheets.
In other words the tenth worksheet will have the sum of all the others at
any given time.
The problem: the first nine worksheetsare being updated on a daily basis.
Is there a way to update the tenth worksheet automatically as per the nine
other worksheets?
Thank you.
 
Ad

Advertisements

V

vezerid

If all sheets have the same structure and so does the summary sheet,
you can use in summary A2 a formula like

=SUM(Sheet1:Sheet9!A2)

Assuming that the detail sheets are placed sequentially in order.

HTH
Kostis Vezerides
 
×

יהונתן טבת

Please, 2 questions:
1. what A2 means?
2. where i have to locate the equation?

Thank
 
D

David Biddulph

1. A2 is a cell reference.

2. You put the equation in your summary sheet. In the example given, you
put the equation in cell A2 in that sheet, and it will add up the values
from cell A2 in each of your other 9 sheets. Adjust your cell reference to
suit your data, and copy the equation to other cells as required.
 
×

יהונתן טבת

please, read again my question.
I am not dealing with summing numbers.
 
D

David Biddulph

Perhaps you had better ask your question again in a newsgroup in your own
language.

In your question, you said:
....
"The tenth worksheet needs to have in it the updated summation of all nine
other worksheets."
....
"In other words the tenth worksheet will have the sum of all the others at
any given time."
....
 
Ad

Advertisements

×

יהונתן טבת

My mistake.
I ment rows as thy are, not numbers.
i.e.: if for example, in sheet1 we have 3 rows & in sheet2 we have 5 rows,
than, in sheet3 we got 8 rows.
 
Ad

Advertisements


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

Top