LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 130
Default Join Sheets after Running Macro

Good Morning,

I have a macro that I have to run on approximately 200 workbooks all within
the same directory - after the macro completes on each worksheet, I need to
paste a certain range from each sheet to a new file and then close the file
and go to the next one in the directory.. At the end I'm looking to have all
of the copied ranges in one combined sheet.

Is this possible?
 
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 join sheets from different workbooks arashi New Users to Excel 1 February 11th 11 10:00 AM
Macro for running on preotected sheets Yogin Excel Discussion (Misc queries) 3 July 23rd 08 05:37 PM
Running macro over different sheets for Essbase Jen[_4_] Excel Programming 11 June 3rd 07 09:26 PM
Running a macro with hidden sheets JonathanW Excel Programming 2 May 1st 07 05:57 AM
Running a one macro on all sheets within the file Eron Excel Programming 3 April 23rd 06 06:25 PM


All times are GMT +1. The time now is 10:37 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"