multiple workbooks to sheets

G

Guest

I have 30 workbooks with one sheet each. All sheets are identical in
structure, only the data varies. What code will copy the sheet in each
workbook to a new sheet in a consolidated workbook. Note this is not a merge.
I need 30 sheets in the consolidated workbook.

Best regards,
 

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

Save specific sheets to new workbooks adding tomorrow's date to na 1
Displaying data Horizontally 3
Macro to merge workbooks onto one worksheet 1
Copy contents from all sheets into 1 1
Copy cell value from one worksheet to matching worksheet in another workbook 4
Copy all workbooks into one workbook 5
Repeat the titles across multiple sheets of a workbook. 6
copy past two existing sheets into 30 workbooks 4

Top