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?
|