Closed Thread
Results 1 to 2 of 2

copying data from many files and adding to a separate file (PLEASE HELP!)

  1. #1
    Registered User
    Join Date
    08-13-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    4

    copying data from many files and adding to a separate file (PLEASE HELP!)

    Please help a newbie out, I am a complete novice at using macros in Excel! Here is my problem:

    I have many "donor" excel documents that each have many separate worksheets, and these worksheets have names that remain the same from "donor" document to "donor" document. I want to create a different "master" document in which I collect all the numbers from one specific column in one specific worksheet from the "donor" document and add them to a column in the "master" document. The numbers in the sheet/column in the "donor" document always start at column A, row 3 but they can then vary how far down the column they go. So, for example, what I want is that the first set of numbers from the specific column/sheet in the "donor" document to be added to column A row 1 of the "master" document, then the the next set of numbers from the next "donor" document's column/sheet should be added underneath, in the next empty cell in the column A of the "master" document, and so on.

    Does this make sense? Please let me know if this easily doable and if so how. I am fairly certain there is a macro that can be written in VBA to do this (?), just I don't have the relevant skills...

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: copying data from many files and adding to a separate file (PLEASE HELP!)

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    http://www.excelforum.com/excel-prog...ease-help.html

    Thread Closed.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copying data from multiple files into new one file.
    By Algus in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-28-2013, 05:45 AM
  2. Copying data from multiple files in a folder to a master file
    By kjshep in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-22-2012, 12:31 PM
  3. Copying data from multiple files (with mult. sheets) into one file and create a graph
    By Macedonia in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-30-2010, 07:37 AM
  4. Copying data from different files into a new file
    By mary johnson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-15-2008, 11:27 AM
  5. [SOLVED] copying data from several files to one excel file
    By sharman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-02-2006, 09:40 AM

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