Automatically compiling many workbooks into one

  • Thread starter Thread starter Jor
  • Start date Start date
J

Jor

I'm needing to copy a bunch of information from a bunch of different excel
files into one massive workbook. I'm hoping to avoid having to do that
manually. I already tried a macro, but it seems as if macros don't work
across multiple files. I don't need to copy all of the information over, but
rather information in specific cells. The information is in different
worksheets in the files. Does anyone know of anything I could do to make this
easier?
 
Back
Top