Hi,
I have about 50 xls files with each 6 sheets.
Now I would like to create 6 workbooks with 50 sheets.
What I need:
for all files in a certain directory:
copy all sheet(1) to a given workbook(1.xls) as a new sheet.
copy all sheet(2) to given workbook(2.xls) as a new sheet.
... for all 6 sheets
I found something similar here http://vbaexpress.com/kb/getarticle.php?kb_id=773
but this copies all info into 1 worksheet...
Can someone help me out on this one?
Thanks in advance!
Regards
Jokada