SUMING VARIOUS LINE ITEMS FROM MULTILPLE WORKBOOKS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Compile data from several workbooks 1
problem with linked workbook 1
Multiple workbook data imported into single workbook 4
Serious Excel Challenge 0
Copy worksheet from one workbook to a master workbook 2
Excel Populate workbook A from Data in workbook B based off criteria in Workbook C 0
combine multiple spreadsheets into one workbook 1

Back
Top