moving worksheets

M

mike

I have 57 different workbooks containing two worksheets each. At the end of
each month I need to move the two worksheets out of each workbook into one
new workbook and then add two new worksheets into the 57 workbooks. I do
this now by using the copy and move functions. Is there a quicker way? Is
there some sort of batch file I could use?

Thanks in advance,
Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top