Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / January 2008

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kat - 01 Oct 2007 17:29 GMT
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".
Ron de Bruin - 01 Oct 2007 17:35 GMT
See this page for a few ways Kat
http://www.rondebruin.nl/linksum.htm

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> 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".
Kat - 01 Oct 2007 17:50 GMT
Thanks Ron!  I'll give that a try after all my patients have gone!  

> See this page for a few ways Kat
> http://www.rondebruin.nl/linksum.htm
[quoted text clipped - 4 lines]
> > For example on sheet one I want to run the totals from each separate
> > worksheet in cell b25 onto the "totals sheet".
Kat - 03 Oct 2007 15:41 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

> See this page for a few ways Kat
> http://www.rondebruin.nl/linksum.htm
[quoted text clipped - 4 lines]
> > For example on sheet one I want to run the totals from each separate
> > worksheet in cell b25 onto the "totals sheet".
bernieb - 07 Jan 2008 18:03 GMT
Ron...thank you so much...I have been trying to figure this out for some
time!!!

> See this page for a few ways Kat
> http://www.rondebruin.nl/linksum.htm
[quoted text clipped - 4 lines]
> > For example on sheet one I want to run the totals from each separate
> > worksheet in cell b25 onto the "totals sheet".
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.