Results 1 to 2 of 2

Copy specific sheet from different workbooks

Threaded View

YasserKhalil Copy specific sheet from... 03-01-2015, 11:20 AM
YasserKhalil Re: Copy specific sheet from... 03-01-2015, 11:22 AM
  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Copy specific sheet from different workbooks

    Hello everybody
    I have an attachment .. In the attachment there's the main workbook which contains the code that I want to edit
    The code is supposed to copy Sheet1 from all the workbooks inside the folder named "Files"
    It is working but the sheets copied in descending order ... In other words the sheet names which resulted after executing the code appear as following : 7 - 6 - 5 - 4 - 3 - 2 - 1
    All what I need to make the new sheets named 1 - 2 - 3 - 4 - 5 - 6 - 7
    I appreciate any help
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Paste data from one sheet to specific sheet in multiple workbooks
    By tstrebel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-30-2014, 01:34 PM
  2. [SOLVED] Copy rows with specific text in specific column into specific sheet
    By Valemaar in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-22-2014, 03:23 PM
  3. VBA for copy specific name sheet from other workbooks
    By santosh226001 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-08-2014, 05:16 AM
  4. Macro to copy values from specific columns from different workbooks to one sheet
    By sksajid7 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-11-2013, 09:50 AM
  5. Macro to extract data from multiple workbooks, specific sheet, specific cells
    By crissandraauree in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2012, 03:54 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1