+ Reply to Thread
Results 1 to 3 of 3

Copy Data From Multiple Open Workbooks to Another Workbook with Separate Worksheets

  1. #1
    Registered User
    Join Date
    07-20-2012
    Location
    Portland, TN
    MS-Off Ver
    Excel 2007
    Posts
    5

    Copy Data From Multiple Open Workbooks to Another Workbook with Separate Worksheets


    I found this code on another thread
    http://www.excelforum.com/excel-prog...-workbook.html

    Please Login or Register  to view this content.
    The thing is that I am pulling files from SharePoint, opening each of them but not saving them because I don't need to save them. I just need to copy the data from "Sheet1" for each file and put the data on separate worksheets on another workbook.
    Right now, all the data is going to one worksheet but I need the data of each workbook "Sheet 1" to go to separate worksheets.
    If someone can help me with this will be greatly appreciated.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Copy Data From Multiple Open Workbooks to Another Workbook with Separate Worksheets

    Hello lupitenis ,

    Welcome to the Forum!

    If the other workbooks are being opened in Sharepoint, are the workbooks being opened in separate instances of Excel? By that I mean, do you see two or more minimized Excel windows?

  3. #3
    Registered User
    Join Date
    07-20-2012
    Location
    Portland, TN
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Copy Data From Multiple Open Workbooks to Another Workbook with Separate Worksheets

    yes, they are in separate excel windows.

+ 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