Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Folder-workbooks (Excel 2000)

    Hi all,
    I have a collection of workbooks in a folder that I want to extract information from, all based on one template. What I would like to do is copy and paste 4 values from each workbook in the folder to generate a graph.

    Is there a Post that maybe someone has seen that might help me?

    Thanks,
    Darryl.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Folder-workbooks (Excel 2000)

    The easiest way might be to open the 4 workbooks. In the workbook that you want the graph data (a 5th WB?) add direct links to the other workbook.

    In a cell enter an equal sign (=)
    then with the mouse select window and choose the first file, select the sheet with the number, and select the cell then hit <enter>

    repeat in the other 3 cells.

    Now you have the numbers linked It will read the data even if the books are closed.

    You can keep them linked or if you want just a "copy" of the values, select the range, copy and paste specal - values.

    Steve

  3. #3
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Folder-workbooks (Excel 2000)

    Thanks Steve,

    I've been experimenting with that, and it works pretty good, linking is cool, but it only solves one of my problems.

    Thank you,

    Darryl.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Folder-workbooks (Excel 2000)

    <hr>but it only solves one of my problems<hr>

    What is(are) the other one(s)?

    Steve

Posting Permissions

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