Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUMING VARIOUS LINE ITEMS FROM MULTILPLE WORKBOOKS
I have mutilpe workbooks (between 15 and 30) with similiar items in them. I
want to sum all the items in each workbook without having the individural workbooks open at the same time, Is there any way I can add workbook data together without have the workbook open? |
#2
|
|||
|
|||
The first time have all the workbooks open. Create a formula on your 'main'
workbook that references the other workbooks. Save and close all. Next time you open your 'main' workbook, it will ask you if you want to refresh the information coming in from the other workbooks. You can answer YES or later in the session you can go to EDIT / LINKS / UPDATE NOW. HTH, Gary Brown "rfhorn" wrote: I have mutilpe workbooks (between 15 and 30) with similiar items in them. I want to sum all the items in each workbook without having the individural workbooks open at the same time, Is there any way I can add workbook data together without have the workbook open? |
#3
|
|||
|
|||
Thank you so much for the solution. I appreciate your help.
Gary Brown" wrote: The first time have all the workbooks open. Create a formula on your 'main' workbook that references the other workbooks. Save and close all. Next time you open your 'main' workbook, it will ask you if you want to refresh the information coming in from the other workbooks. You can answer YES or later in the session you can go to EDIT / LINKS / UPDATE NOW. HTH, Gary Brown "rfhorn" wrote: I have mutilpe workbooks (between 15 and 30) with similiar items in them. I want to sum all the items in each workbook without having the individural workbooks open at the same time, Is there any way I can add workbook data together without have the workbook open? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
coloring overy other line without doing so line by line | Excel Worksheet Functions | |||
Sum Conditional Items by date across workbooks | Excel Worksheet Functions | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
Macro - Skipping a line | Excel Worksheet Functions | |||
Workbooks...I'll try this again... | Excel Discussion (Misc queries) |