View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chris[_15_] chris[_15_] is offline
external usenet poster
 
Posts: 11
Default building new workbook from sheets in different workbooks

Hi,
can anyone help, please?
I've 5 workbooks, each containing the sheets A-Z (Customernames).
Now I need a macro that goes into each of the workbooks, selects all
sheets with name "A" and saves it as new file "A", then goes back and
continues with sheet "B" and so on.
Anyone an idea?