Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking multiple worksheets in one workbook
I have a workbook that contains multiple worksheets that I need to "average"
the results in a new worksheet within the same workbook like a summary page. For example, I have customer surveys from multiple clients that I enter separately into one worksheet. My goal is to then gather all this information into one summarized spreadsheet at the beginning of the workbook. How is this accomplished? I'm not too familiar with the how-to's of doing this at all. I an using Excel 2007. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking multiple worksheets in one workbook
In any worksheet, you can make references to cells in other worksheets. For
example, if i am on shset2 and I want to reference cell B6 in sheet one, the correct syntax is =Sheet1!B6. You can use functions like sum, average, etc the same way -- your cell reference will have the sheet name and ! in from of it. Like: =SUM(Sheet1!D4:D6) "CWhite1972" wrote: I have a workbook that contains multiple worksheets that I need to "average" the results in a new worksheet within the same workbook like a summary page. For example, I have customer surveys from multiple clients that I enter separately into one worksheet. My goal is to then gather all this information into one summarized spreadsheet at the beginning of the workbook. How is this accomplished? I'm not too familiar with the how-to's of doing this at all. I an using Excel 2007. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking multiple worksheets in one workbook
Depends upon how you data is laid out on each sheet.
If your total in each sheet is same cell you can use =AVERAGE(Sheet1:Sheet6!A1:A10) Gord Dibben MS Excel MVP On Mon, 28 Sep 2009 07:39:01 -0700, CWhite1972 wrote: I have a workbook that contains multiple worksheets that I need to "average" the results in a new worksheet within the same workbook like a summary page. For example, I have customer surveys from multiple clients that I enter separately into one worksheet. My goal is to then gather all this information into one summarized spreadsheet at the beginning of the workbook. How is this accomplished? I'm not too familiar with the how-to's of doing this at all. I an using Excel 2007. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking two worksheets in the same workbook | Excel Worksheet Functions | |||
Linking of worksheets in a workbook | Excel Discussion (Misc queries) | |||
Linking to worksheets from another workbook | Excel Discussion (Misc queries) | |||
linking several worksheets to one workbook | Excel Discussion (Misc queries) | |||
linking worksheets in same workbook | Excel Discussion (Misc queries) |