A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

updating Excel workbook



 
 
Thread Tools Display Modes
  #1  
Old December 10th, 2007, 01:29 PM posted to microsoft.public.excel.worksheet.functions
יהונתן טבת
external usenet poster
 
Posts: 5
Default updating Excel workbook

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.

  #2  
Old December 10th, 2007, 03:02 PM posted to microsoft.public.excel.worksheet.functions
vezerid
external usenet poster
 
Posts: 739
Default updating Excel workbook

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

On Dec 10, 2:29 pm, יהו×*תן טבת wrote:
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.


  #3  
Old December 10th, 2007, 04:32 PM posted to microsoft.public.excel.worksheet.functions
יהונתן טבת
external usenet poster
 
Posts: 5
Default updating Excel workbook

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

Thank


"vezerid" wrote:

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

On Dec 10, 2:29 pm, יהו×*תן טבת wrote:
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.



  #4  
Old December 10th, 2007, 05:18 PM posted to microsoft.public.excel.worksheet.functions
David Biddulph
external usenet poster
 
Posts: 8,714
Default updating Excel workbook

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.
--
David Biddulph

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

Thank


"vezerid" wrote:

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

On Dec 10, 2:29 pm, ?????? ??? wrote:
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.





  #5  
Old December 11th, 2007, 12:26 PM posted to microsoft.public.excel.worksheet.functions
יהונתן טבת
external usenet poster
 
Posts: 5
Default updating Excel workbook

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


"David Biddulph" wrote:

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.
--
David Biddulph

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

Thank


"vezerid" wrote:

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

On Dec 10, 2:29 pm, ?????? ??? wrote:
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.





  #6  
Old December 11th, 2007, 12:45 PM posted to microsoft.public.excel.worksheet.functions
David Biddulph
external usenet poster
 
Posts: 8,714
Default updating Excel workbook

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."
....
--
David Biddulph

"?????? ???" wrote in message
...
please, read again my question.
I am not dealing with summing numbers.

"David Biddulph" wrote:


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.
--
David Biddulph

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

Thank


"vezerid" wrote:

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

On Dec 10, 2:29 pm, ?????? ??? wrote:
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.







  #7  
Old December 11th, 2007, 01:26 PM posted to microsoft.public.excel.worksheet.functions
יהונתן טבת
external usenet poster
 
Posts: 5
Default updating Excel workbook

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.


"David Biddulph" wrote:

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."
....
--
David Biddulph

"?????? ???" wrote in message
...
please, read again my question.
I am not dealing with summing numbers.

"David Biddulph" wrote:


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.
--
David Biddulph

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

Thank


"vezerid" wrote:

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

On Dec 10, 2:29 pm, ?????? ??? wrote:
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.








  #8  
Old December 11th, 2007, 07:47 PM posted to microsoft.public.excel.worksheet.functions
יהונתן טבת
external usenet poster
 
Posts: 5
Default updating Excel workbook

Here is tn example:http://www.mediafire.com/?f2gmbm9y4gv


"David Biddulph" wrote:

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."
....
--
David Biddulph

"?????? ???" wrote in message
...
please, read again my question.
I am not dealing with summing numbers.

"David Biddulph" wrote:


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.
--
David Biddulph

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

Thank


"vezerid" wrote:

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

On Dec 10, 2:29 pm, ?????? ??? wrote:
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.








 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:56 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.