LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
hlflorek
 
Posts: n/a
Default Totaling data from multiple workbooks.

I have to deal with about 15 different part numbers on a daily basis, and
turn in reports every day. My daily workbook has 15 sheets, one for each part
number. I also do a daily summary which totals up my daily numbers (good
parts, bad parts, repaired parts, parts returned from customer, etc.). Is
there any way that I can make a weekly summary sheet to total the 5 daily
summaries from the different workbooks? I managed to get the formulas right
for the daily summaries, but I'm no rocket scientist, so I need to keep this
as easy as possible. Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I pull data from multiple user workbooks into one? Stuart Peters Excel Discussion (Misc queries) 4 April 8th 06 11:29 AM
combining multiple rows of data into one single row of data myersjl Excel Worksheet Functions 0 March 30th 06 10:39 PM
Sorting Data from Multiple Workbooks KSW Excel Discussion (Misc queries) 0 March 15th 06 09:13 PM
AHHHH-Get Data from Multiple Excel workbooks JAA149 Excel Discussion (Misc queries) 5 October 30th 05 05:19 PM
Reference multiple cells in if statement PAR Excel Worksheet Functions 1 June 10th 05 06:28 AM


All times are GMT +1. The time now is 10:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"