How to copy the work sheets from different workbooks into one?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a 30 work books and each book has 5 sheets.
I want to copy the first sheet from each work book to a single work book
'A', so that work book 'A' will have 30 sheets .

Manually it takes time as I need to copy hundreds of work sheets...

Can you please help me ?

Thanks,
Sesh
 
You must log in or register to reply here.

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

Similar Threads

Excel Move or Copy Stopped Working? 0
Merge Multiple workbook sheets into one workbook 0
Copy or Move a spreadsheet 1
Copy Exact Formula 1
update data from one workbook to another 4
Taking w/sheets out of a workbook 5
copying data from master ti individual sheets 3
How to copy drop down list to next sheet 3

Back
Top