Tags: 29th, adding, create, excel, figure, microsoft, msdn, multiple, numerical, page, separate, sheet, software, total, totals, workbook, worksheets

Adding data from multiple worksheets onto a total's page?

On Microsoft » Microsoft Excel

4,018 words with 4 Comments; publish: Fri, 23 May 2008 18:08:00 GMT; (30646.88, « »)

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

All Comments

Leave a comment...

  • 4 Comments
    • 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" <Kat.excel.todaysummary.com.discussions.microsoft.com> wrote in message news:C6A9C297-5EE6-489F-A5A6-B1D4B1E1CF98.excel.todaysummary.com.microsoft.com...

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

      #1; Fri, 23 May 2008 18:10:00 GMT
    • 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" <Kat.excel.todaysummary.com.discussions.microsoft.com> wrote in message news:C6A9C297-5EE6-489F-A5A6-B1D4B1E1CF98.excel.todaysummary.com.microsoft.com...

      > > 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; Fri, 23 May 2008 18:11:00 GMT
    • 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" <Kat.excel.todaysummary.com.discussions.microsoft.com> wrote in message news:C6A9C297-5EE6-489F-A5A6-B1D4B1E1CF98.excel.todaysummary.com.microsoft.com...

      > > 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; Fri, 23 May 2008 18:12:00 GMT
    • 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" <Kat.excel.todaysummary.com.discussions.microsoft.com> wrote in message news:C6A9C297-5EE6-489F-A5A6-B1D4B1E1CF98.excel.todaysummary.com.microsoft.com...

      > > 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; Fri, 23 May 2008 18:13:00 GMT