Inserting Sheets from multiple files

F

fgwiii

I am trying to find out if it is possible to take the 1st sheet from
multiple workbooks in a directory (ie. C:\data) and append them into
the first sheet of a single workbook?

Thanks,

Fred
 
J

Jim Rech

There is no built-in Excel tool to do this. You could write a macro to do
it of course. Sorry I do not have an example.


--
Jim
|
| I am trying to find out if it is possible to take the 1st sheet from
| multiple workbooks in a directory (ie. C:\data) and append them into
| the first sheet of a single workbook?
|
| Thanks,
|
| Fred
|
|
| --
| fgwiii
 
K

Ken Wright

Try here:-

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
Top