Adding worksheets to tabs

[Mike C.]

I have >30 worksheets that I want to add as tabs to the first worksheet I created. Is there an easy way to do this or does it have to be done one at a time? They are all in one folder

Thanks

Mike

 

[Earl Kiosterud]

Mike,

I think you're saying you have 30 workbook files, with one sheet in each
(?), that you want to consolidate into the first workbook. If so, have the
first workbook open, open each of the others, right-click the sheet tab,
select Move or Copy, open the To Book box, and select the first workbook.
Since you've removed the only sheet in the workbook, it will delete that
workbook file. Be sure to save the first one -- it now has those that you've
moved.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

I have >30 worksheets that I want to add as tabs to the first worksheet I

created. Is there an easy way to do this or does it have to be done one at a
time? They are all in one folder.

 

[Max]

Maybe also try Ron's page at:

http://www.rondebruin.nl/copy3.htm#sheet

Look under the heading:

Copy a sheet from each workbook into your workbook

There's a Sub TestFile6() provided

--
Rgds
Max
xl 97
--
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
---

I have >30 worksheets that I want to add as tabs to the

first worksheet I created. Is there an easy way to do this
or does it have to be done one at a time? They are all in
one folder.