View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nora Najem
 
Posts: n/a
Default Sum values from 15 workbooks

Hello

I ceated a workbook named (Result) which should sum the values from 15
workbooks (each book also is consisted of 12 sheets and a "TOTAL" sheet).

I want to sum the values of the "Total" Sheets, which are all identical,
into one workbook.

My questions a

- What is the appropriate way to do that?.
- Does it matter if the worksheets in all workbooks are protected?
- Can I use the consolidation feature and how?

Thank you very much
--
Microsoft Biased