| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding data from multiple worksheets onto a total's page??
I'm trying to add numerical data from 28 separate worksheets onto a "totals
sheet" (the 29th workbook) and cannot figure out how to create the formula. What should I be using to create this specialized formula? For example on sheet one I want to run the totals from each separate worksheet in cell b25 onto the "totals sheet". |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding data from multiple worksheets onto a total's page??
See this page for a few ways Kat
http://www.rondebruin.nl/linksum.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Kat" wrote in message ... I'm trying to add numerical data from 28 separate worksheets onto a "totals sheet" (the 29th workbook) and cannot figure out how to create the formula. What should I be using to create this specialized formula? For example on sheet one I want to run the totals from each separate worksheet in cell b25 onto the "totals sheet". |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding data from multiple worksheets onto a total's page??
Thanks Ron! I'll give that a try after all my patients have gone!
"Ron de Bruin" wrote: See this page for a few ways Kat http://www.rondebruin.nl/linksum.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Kat" wrote in message ... I'm trying to add numerical data from 28 separate worksheets onto a "totals sheet" (the 29th workbook) and cannot figure out how to create the formula. What should I be using to create this specialized formula? For example on sheet one I want to run the totals from each separate worksheet in cell b25 onto the "totals sheet". |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding data from multiple worksheets onto a total's page??
Ron,
Just wanted you to know that I was able to get what I wanted - thanks to your help! Have a Great End of Week! Katherine "Ron de Bruin" wrote: See this page for a few ways Kat http://www.rondebruin.nl/linksum.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Kat" wrote in message ... I'm trying to add numerical data from 28 separate worksheets onto a "totals sheet" (the 29th workbook) and cannot figure out how to create the formula. What should I be using to create this specialized formula? For example on sheet one I want to run the totals from each separate worksheet in cell b25 onto the "totals sheet". |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding data from multiple worksheets onto a total's page??
Ron...thank you so much...I have been trying to figure this out for some
time!!! "Ron de Bruin" wrote: See this page for a few ways Kat http://www.rondebruin.nl/linksum.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Kat" wrote in message ... I'm trying to add numerical data from 28 separate worksheets onto a "totals sheet" (the 29th workbook) and cannot figure out how to create the formula. What should I be using to create this specialized formula? For example on sheet one I want to run the totals from each separate worksheet in cell b25 onto the "totals sheet". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add page numbers to multiple worksheets without changing page setu | Excel Discussion (Misc queries) | |||
| Printing multiple page worksheets on 1 single page | Excel Discussion (Misc queries) | |||
| Selecting/Adding data from Multiple Worksheets | Excel Discussion (Misc queries) | |||
| Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
Linear Mode
