Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 workbook not updating values | Excel Worksheet Functions | |||
Automatically updating a workbook from a different workbook day by | Excel Discussion (Misc queries) | |||
My workbook links are not updating (its 30,000 KB size workbook). | Excel Discussion (Misc queries) | |||
Auto updating a workbook with data from another workbook | Excel Discussion (Misc queries) | |||
updating excel worksheets to another workbook | Excel Worksheet Functions |