Importing workbooks as sheets

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

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


Any help is appreciated.


---
Message posted from http://www.ExcelForum.com/

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!


--
Arvi Laanemets
(Don't use my reply address - it's spam-trap)


"stillme1 " wrote in message
...
Using excel 97, I use to be able to consolidate multiple workbooks into
one workbook. The single workbook would have several sheets named after
the workbooks imported or consolidated. Can't remember what I did.....I
know vb was not involved. I just remember doing something, selecting
multiple sheets and it happened.

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


Any help is appreciated.


---
Message posted from http://www.ExcelForum.com/

Right 10 was a typo, I meant 20. It could be 100 each though. It's hard
to explain.

Picture this:

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


---
Message posted from http://www.ExcelForum.com/