Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summing the same cell in multiple workbooks
I have 250 folders (one for each customer), and multiple workbooks in
each folder. All of the workbooks are identical in structure/cell formulas, etc..... Whenever a customer issues a purchase order, a new workbook is created for that order (the worksheets a RFQ, Worksheet, Quote, Order, Shipping, RMA). Each purchase order is saved in a new workbook under the company name & PO# (example: GeneralDevicesPO1243.xlsm) Therefore, General Devices has its own folder, with as many workbooks as they have purchase orders issued. Like I mentioned, the workbooks are all identical in structure. On the "Order" sheet of the workbook, J40 is the cell marked "Total Profit". I need to have just one worksheet which keeps running totals of all of the workbooks in all of the folders, even after I've added folders when new companies order from us. I think this might be a "consolidate" function, but I don't know how to set it up. Any ideas on how I would do this? Your help is priceless. Summary: Folder Cust Maint: Sub Folder General Devices: WorkbookGeneralDevicesPO1243.xlsm..... I want to make a worksheet called "Total Profit" and place just one copy in the "Cust Maint" folder. Thank you in advance. Daryl |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summing the same cell in multiple workbooks
On Jan 25, 2:48*pm, wrote:
I have 250 folders (one for each customer), and multiple workbooks in each folder. *All of the workbooks are identical in structure/cell formulas, etc..... *Whenever a customer issues a purchase order, a new workbook is created for that order (the worksheets a RFQ, Worksheet, Quote, Order, Shipping, RMA). *Each purchase order is saved in a new workbook under the company name & PO# (example: GeneralDevicesPO1243.xlsm) *Therefore, General Devices has its own folder, with as many workbooks as they have purchase orders issued. Like I mentioned, the workbooks are all identical in structure. *On the "Order" sheet of the workbook, J40 is the cell marked "Total Profit". *I need to have just one worksheet which keeps running totals of all of the workbooks in all of the folders, even after I've added folders when new companies order from us. *I think this might be a "consolidate" function, but I don't know how to set it up. *Any ideas on how I would do this? *Your help is priceless. Summary: *Folder Cust Maint: Sub Folder General Devices: WorkbookGeneralDevicesPO1243.xlsm..... *I want to make a worksheet called "Total Profit" and place just one copy in the "Cust Maint" folder. Thank you in advance. Daryl I'm sorry for not mentioning that I need the "Total Profit" worksheet to keep running totals of the "Total Profit" cells (J40) from all of the worksheets. sorry. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summing the same cell in multiple workbooks
Maybe you can use this add-in to get the cell value from each workbook
http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm wrote in message ... I have 250 folders (one for each customer), and multiple workbooks in each folder. All of the workbooks are identical in structure/cell formulas, etc..... Whenever a customer issues a purchase order, a new workbook is created for that order (the worksheets a RFQ, Worksheet, Quote, Order, Shipping, RMA). Each purchase order is saved in a new workbook under the company name & PO# (example: GeneralDevicesPO1243.xlsm) Therefore, General Devices has its own folder, with as many workbooks as they have purchase orders issued. Like I mentioned, the workbooks are all identical in structure. On the "Order" sheet of the workbook, J40 is the cell marked "Total Profit". I need to have just one worksheet which keeps running totals of all of the workbooks in all of the folders, even after I've added folders when new companies order from us. I think this might be a "consolidate" function, but I don't know how to set it up. Any ideas on how I would do this? Your help is priceless. Summary: Folder Cust Maint: Sub Folder General Devices: WorkbookGeneralDevicesPO1243.xlsm..... I want to make a worksheet called "Total Profit" and place just one copy in the "Cust Maint" folder. Thank you in advance. Daryl |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to lookup multiple values and summing them up in one cell | Excel Worksheet Functions | |||
cell reference for multiple workbooks | Excel Discussion (Misc queries) | |||
Independently Summing Multiple Text Options Within a Cell | Excel Worksheet Functions | |||
Summing same cell/cells from multiple sheets | Excel Worksheet Functions | |||
Summing Values from different workbooks | Excel Discussion (Misc queries) |