Excel Data Consolidation ; Multiple workbooks

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

Guest

I understand how to use data consolidate on multiple worksheets in a single workbook.

My case is multiple workbooks, each with a "roll up" of data using data consolidation.

I am trying to consolidate the roll ups from the multiple workbooks into a Grand Roll up and having a bear of a time making it pull together.

Help! Thanks.
 
A Data Consolidate will work with multiple workbooks. It's just a matter of
adding the right reference, e.g.:

[SrcBook.xls]Sheet2!$B$2:$D$12

What's your specific problem?
 
Back
Top