Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Insert Existing Worksheets into a new Workbook
I have a set of many single page worksheets with calculations; I want to make
a single Workbook using all of those pages. Then I want to extract data from a certain cell on each Worksheet and SUM that data on the last page of the Workbook. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Insert Existing Worksheets into a new Workbook
In EXCEL 2007 in order to extract and sum data on a specific page of the
Workbook:- 1. Assume I have a Workbook set up in which there are 4 Worksheets and I wish to sum cell C6 from 3 of those Worksheets in Sheet1. 2. In cell C6 of Sheet1 (this is where I want the total to appear):- Home / Editing group / AutoSum / 3. Now click on the first Worksheet you wish to include in the total and click in cell C6. 4. Hold down the SHIFT key and click on the tab of the last (furthest to the right) Worksheet whose cell C6 you wish to include in the total. Release the SHIFT KEY. 5. Now hit the tick to the left of the fx button to the left of the Formula bar. 6. You will now have the total of cell C6 in Sheet1 where the formula is:- =SUM(Sheet2:Sheet4!C6) Please hit Yes if my comments have helped. Thanks. "CWO4 Dave Mann" wrote: I have a set of many single page worksheets with calculations; I want to make a single Workbook using all of those pages. Then I want to extract data from a certain cell on each Worksheet and SUM that data on the last page of the Workbook. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Insert Existing Worksheets into a new Workbook
Hi,
take a look at Ron de Bruin web http://www.rondebruin.nl/copy2.htm "CWO4 Dave Mann" wrote: I have a set of many single page worksheets with calculations; I want to make a single Workbook using all of those pages. Then I want to extract data from a certain cell on each Worksheet and SUM that data on the last page of the Workbook. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add NOT insert additional worksheet to existing workbook. | Excel Worksheet Functions | |||
ADDING MORE WORKSHEETS TO AN EXISTING WORKBOOK | Excel Discussion (Misc queries) | |||
Need to insert a template with formulas into an existing workbook | Excel Worksheet Functions | |||
How do I insert a new work sheet into an existing workbook? | Excel Discussion (Misc queries) | |||
Can't Insert of remove worksheet in an existing workbook | Excel Discussion (Misc queries) |