LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Bewilderd jim
 
Posts: n/a
Default CREATE MACRO TO COPY MULTIPLE WORKSHEETS

Using the record macro function, I can not copy multiple (50+) worksheets
from other files into one workbook. I have tried two ways. First way was
copying one sheet a a time until I rec'd a too many fonts error. The second
way was to select all sheets ina workbook and copy them to another. With the
second method I rec'd a macro error. Can anyone be of any help?
 
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 create macro Carl Bowman Excel Discussion (Misc queries) 2 February 6th 05 10:49 AM
Compare 2 Worksheets Create a 3rd depending on results Kevin Excel Discussion (Misc queries) 1 February 4th 05 11:49 PM
How do I record a macro which should work on multiple files ? Venkataraman.P.E Excel Discussion (Misc queries) 2 January 16th 05 10:26 AM
Macro for multiple charts JS Excel Worksheet Functions 1 November 19th 04 03:44 AM
copy pivot table to multiple worksheets Todd Excel Worksheet Functions 2 November 19th 04 03:16 AM


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

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

About Us

"It's about Microsoft Excel"