Multiple sheet import

J

John

I want to gather up about 80-100 workbooks into one workbook. Each
workbook has only one sheet. Is there a handy way of doing this? Like
"import" and then select all 60 or something? The workbooks are named by
dates in the form 05-05-2006.xls etc. They are records of billing on
that date. I want a billing workbook instead of separate sheets.

I am using office 2003 excel. I can't find ANY import function on the
toolbars which leaves me opening each file and exporting it to the new
workbook.

Thanks

John
 

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

Copy cell value from one worksheet to matching worksheet in another workbook 4
Update #REF! to Active Workbook 1
VBA macro guru help needed! 1
Repeat the titles across multiple sheets of a workbook. 6
Import multiple workbooks to current workbook in specified row number 0
Save specific sheets to new workbooks adding tomorrow's date to na 1
How could I split a spreadsheet containing 600 rows, so there's 100rows in each new workbook 6
Adding ws information to cell in new wb & saving with ws name 7

Top