Linking multiple files

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

Guest

I want to link multiple Excel files together and create a summary in a
separate worksheet. All of the files are formatted exactly alike. I don't
want to combine them into one worksheet because each sheet is needed on its
own. Any suggestions?
 
Hi

yes, check out Consolidation on the Data menu or Pivot Tables -
consolidating multiple ranges.

Cheers
JulieD
 
Back
Top