View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve[_4_] Steve[_4_] is offline
external usenet poster
 
Posts: 184
Default copy sheets from many files into 1

Hi everyone. I have a directory of excel files, each containing
multiple sheets (each may have different number of sheets). Can I
consolidate all sheets into 1 file? Basically copying each sheet from
each file and dropping each sheet into a single file. Thanks!