View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lmarstin lmarstin is offline
external usenet poster
 
Posts: 4
Default COMBINING WORKBOOKS

I have 32 workbooks with 3 worksheets each. Each worksheet in each workbook
is named the same. I need to combine all 32 workbooks into one files with
each of the 3 sheets moved. This will make for a total of 96 sheets. I
really don't want to have to open each file and copy the worksheets to a
master sheet.