Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 111
Default want to copy many workbooks into 1 workbook

i have a folder with over 400 workbooks (1 worksheet per workbook). i want
to copy these workbooks into a single workbook with 400 tabs. is there a
fast way to do this? say a macro?

thanks in advance
--
aprilshowers
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default want to copy many workbooks into 1 workbook

Check out the copy paste merge examples from Ron's site...

http://www.rondebruin.nl/tips.htm
--
HTH...

Jim Thomlinson


"april" wrote:

i have a folder with over 400 workbooks (1 worksheet per workbook). i want
to copy these workbooks into a single workbook with 400 tabs. is there a
fast way to do this? say a macro?

thanks in advance
--
aprilshowers

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to copy an image (or picture) from one workbook to a new sheetin another workbook Ruchir Excel Worksheet Functions 1 July 25th 08 07:29 AM
Excel-how to link source workbook to copy of destination workbook D Lynn Excel Worksheet Functions 1 May 29th 08 05:36 PM
HOW DO I COPY AND RENAME A WORKBOOK LINKED TO OTHER WORKBOOKS rlh3 Excel Discussion (Misc queries) 1 January 2nd 08 05:49 PM
Copy/ move selected data from workbooks to seperate worksheets or workbooks Positive Excel Worksheet Functions 1 August 30th 07 04:54 PM
copy selected tabs from multiple workbooks to a new workbook chris Excel Worksheet Functions 0 July 12th 07 03:46 PM


All times are GMT +1. The time now is 11:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"