Results 1 to 6 of 6

Gathering data from different documents

This is a discussion on Gathering data from different documents within the Excel Questions forums, part of the Question Forums category; Hello. I'm wondering if there is any way that I could write some sort of formula that could take a ...

  1. #1
    New Member
    Join Date
    Jun 2002
    Posts
    8

    Default

    Hello. I'm wondering if there is any way that I could write some sort of formula that could take a certain number, or numbers, from all the documents in one folder, and place them in a row on one document. Like say, tell it to go to folder "May 2002", and go to cell D14 of every document in that folder, and place it in such and such a place. Is that possible? Thanks!
    Regards,
    Mark

    [ This Message was edited by: Mark Smith on 2002-06-06 18:40 ]

  2. #2
    New Member
    Join Date
    Jun 2002
    Posts
    8

    Default

    I hope somebody will reply!
    Regards,
    Mark

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    538

    Default

    You seem to be looking for a VBA solution. But i think you should prpopably start by using manual formulas.
    Try opening the two workbooks. and then making a fomula bwtween them.
    so type in = and then change sheets and click on the cell you want to reference. then check the formula and see what it says.

    This is a good way to start!

  4. #4
    New Member
    Join Date
    Jun 2002
    Posts
    21

    Default

    Hi, I am no excel expert, but I have dealt with exactly this problem (many many many times)...


    Your formula, in your target cell, target file, should refer to the reference directory, reference file name, reference file name SHEET name, and cell number like the following...

    Formula in target cell:

    ='Folder1:Folder2:[ReferenceFileName]ReferenceSheetName'!$E$1

    My example; I needed to call upon data from 400 different spreadsheets, and place that data on a single spreadsheet. I made sure that the location of each and every piece of data I needed was in the same cell of each and every reference file

    Those files are all kept in the Folder 'Root:KnipovichALL', each file has the SAME basic name structure, with the only difference between files being the number tag at the end.. (K2KNmeas0001, 0002, etc); and the data I wanted was ALWAYS in Cell E1 (or F3, or whatever)...

    Like so.

    ='Root:KnipovichALL:[K2KNmeas0001]K2KNmeas0001'!$E$1

  5. #5
    New Member
    Join Date
    Jun 2002
    Posts
    8

    Default

    Thanks! Is there any other way that would make this process simpler?

    Regards
    Mark

  6. #6
    New Member
    Join Date
    Jun 2002
    Posts
    8

    Default

    sorry, I posted my last post before seeing that danielc has responded - I'll have a look at your post now!
    regards,
    Mark

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com