+ Reply to Thread
Results 1 to 4 of 4

Search folder and copy sheets from multiple files into a master file with formatting

  1. #1
    Forum Contributor
    Join Date
    04-29-2010
    Location
    Tallahassee, FL
    MS-Off Ver
    365
    Posts
    100

    Smile Search folder and copy sheets from multiple files into a master file with formatting

    I have found code on the site that is similar to what I need, but have been unable to adapt any of it to make it work. Please help me find a way to:

    (1) Search a single folder for .xls files

    (2) Copy the first sheet of each file (there is only one sheet in each file) and paste them into individual sheets in a master workbook with the original formatting and sheet name on the tabs. They do not have to be pasted as values.

    The closest thing I have found (that works for me) is the very basic code below, but this requires all of the workbooks to be open and the names of sheets and workbooks within the code. I'm working with 32 workbooks, so I had hoped I could find a way to automate the whole process. Finally, it needs to be compatible with Excel 2003. Thank you.

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Search folder and copy sheets from multiple files into a master file with formatt

    Use this code -
    Please Login or Register  to view this content.
    Last edited by arlu1201; 01-27-2012 at 01:37 PM.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Contributor
    Join Date
    04-29-2010
    Location
    Tallahassee, FL
    MS-Off Ver
    365
    Posts
    100

    Re: Search folder and copy sheets from multiple files into a master file with formatt

    I'm sorry arlu1201, I had already found the answer before I saw your post. Thank you for taking the time to help me.

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Search folder and copy sheets from multiple files into a master file with formatt

    Found the solution where? As per forum rules, please provide a link to the solution you found elsewhere. Or post your own solution here to complete the thread if you resolved it on your own. This is a searchable forum, intended to help others. Thanks.

    Also, if that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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