Importing workbooks as sheets

  • Thread starter Thread starter stillme1
  • Start date Start date
S

stillme1

Using excel 97, I use to be able to consolidate multiple workbooks int
one workbook. The single workbook would have several sheets named afte
the workbooks imported or consolidated. Can't remember what I did.....
know vb was not involved. I just remember doing something, selectin
multiple sheets and it happened.

I have one folder with 20 workbooks and I'm trying to get them all i
to one workbook with 10 sheets.


Any help is appreciated.:confused
 
Hi


Open the workbook, to where you want insert sheet (target), and the workbook
with sheet you want to insert (source).

With source sheet activated, right-click on sheet tab and select from
drop-down menu 'Move or copy ...'. In 'To book' field select target
workbook, when you want preserve source sheet in source workbook, then check
'Create a copy' checkbox, and finally press OK. Repeat this for all sheets
you want to get into target workbook.

With 20 source workbooks, you get at least 20 sheets (when all sources are
single-sheet workbooks) in your target workbook. Or the number 10 is a typo,
or we need more details about your problem to give you more help!
 
Right 10 was a typo, I meant 20. It could be 100 each though. It's har
to explain.

Picture this:

50 excel files in one folder. I want to view them all, but I don't wan
to open 50 files. I'd rather open one file and be able to click 5
sheet tabs at the bottom of that one file to view the othe
spreadsheets in the folder. That would require importing the othe
excel files into the first file I open. Thanks for helping
 
Back
Top