View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steph[_7_] Steph[_7_] is offline
external usenet poster
 
Posts: 7
Default Copy sheet from multiple files

Hello. I have a folder that has multiple files. I need several of the
files, but not all. Each file has only 1 sheet in it.

I would like to use multiselect to choose the files I need, and copy the
sheet from each of the selected files into a single file. So for example,
if I chose 7 files, my master file would have 7 sheets in it.

Thanks!