View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chirag Ruparelia Chirag Ruparelia is offline
external usenet poster
 
Posts: 2
Default Merging several workbooks from folder to 1 workbook in different s

Hi All,
looking for a macro wherein I can extract details from 10 different
workbooks located in particular folder into a new workbook , details of each
should be on new sheets.

eg. there should be 10 sheets having all the details of 10 workbook located
in a particular folder.

Appreciated your help

Regards,
Chirag